[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Update a record with NO-LOCK status

  • Thread starter Thread starter ChUIMonster
  • Start date Start date
Status
Not open for further replies.
C

ChUIMonster

Guest
If you can FIND CURRENT after the transaction you are in a state of sin. That means that the record scope exceeds the transaction scope. The proper way to scope a record to a transaction block is via strong scope and a FOR statement: define buffer upd_cust for customer. for each customer no-lock: if customer.discount > 10 then do FOR upd_cust transaction: /* strong scope the “upd_cust" buffer */ find upd_cust exclusive-lock where upd_cust.custNum = customer.custNum. upd_cust.discount = 10. end. end.

Continue reading...
 
Status
Not open for further replies.
Back
Top