Search results

  1. O

    Release with if avail.

    Ok. Thanks Everybody.
  2. O

    Release with if avail.

    Here is a code that uses optimistic locking strategy. Can you make it work without release statement keeping the same strategy? (This is from ABL Essentials Document. I added a repeat to it) /* h-findCurrent.p */ define variable l_cust like customer.custnum. repeat: update l_cust...
  3. O

    Release with if avail.

    Keep dreaming Mr. Shark. I hope one day you will realize that you are just a fish... and that is for your own good. There is more in the world to feel good about than knowing “record scope” and feeling like a shark.. ?;^P
  4. O

    Release with if avail.

    My point was to give an example where release can be used. Ofcourse, release is not required at all if the record scope can be fixed. That part was already said by two of the wizards (99% and 100%). What’s happening here? Some demo of Power? I see that finally the last wizard comes along...
  5. O

    Release with if avail.

    find first pt_mstr no-lock no-error. for first pt_mstr exclusive-lock: end. /** at this point record is in buffer and it is share-locked. So you may want to release it right here. **/ release pt_mstr. pause.
  6. O

    Read last value from csv file

    output to ./t2.txt. put control "~015". output close. unix silent cat ./t2.txt >> ./original.txt. now your original file has carriage return.
  7. O

    Date Format

    you can use client parameter -yr4def to get 4 digit year.
  8. O

    Financial year in the tables

    glc_cal is the table in mfg/pro
  9. O

    Session Triggers for non db field

    on leave anywhere do: if self:name = "aa" then do: if self:screen-value = "yes" then self:screen-value = "no". end. end. run org.p and your org.p is... def var aa as log. def var bb as c. form aa bb with frame f_aa. update aa bb with frame f_aa.
  10. O

    sod_project field added to Generalised codes,but not showing an error

    Do you have a gen code that has fldname = "sod_project" with a Blank value? If so delete that record.
  11. O

    Data present in tables, but not shown in MFG/PRO

    Check the domain field in pt_mstr. May be you are trying to view the data from a different domain.
  12. O

    collated program

    def var iCopies as i no-undo init 2. def var iPages as i no-undo init 3. def var lCollated as l no-undo. def var iCtr as i no-undo. def var iCtr2 as i no-undo. form iCopies label "Copy" iPages label "Page" with frame f_1 down. repeat: update iCopies iPages lCollated with...
  13. O

    installation of progress9.1D on Score Unix6 server

    Minimum OS level for 9.1D for SCO is... SCO OpenServer 5.0.6, 5.0.7
  14. O

    Silent uninstall of Progress/OpedEdge 10.1B

    From Progress Support Site... It is possible to perform a silent uninstall on Windows-based systems from OpenEdge 10.1B onwards. Add –psc_s to the existing uninstall shortcut: OpenEdge 10.2B Uninstall shortcut property as installed: "C:\Program Files\InstallShield Installation...
  15. O

    Critical issue: Persistent procedure.

    If it was calling TTmvplan.p, it should give error "Mismatched number of parameters passed to procedure sub.p. (3234)" and NOT err#3230. May be you have an other version of .r with datatype issue. Recompile plan.p and try it.
  16. O

    converting date to a defined format

    session:date-format = "ymd". message string(today,"99999999"). remember to reset the format once done.
  17. O

    Select Problems

    try this... select a.ca, b.cb from table1 a left outer join table2 b on a.id = b.id and b.anothercolumn like '%hey%'
Top