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

  • Thread starter Thread starter Jeff Ledbetter
  • Start date Start date
Status
Not open for further replies.
J

Jeff Ledbetter

Guest
[quote user="gus bjorklund"] Jeff: When a record is updated, the exclusive lock required to do so CANNOT be released until after the transaction has been committed. This is so because if the lock is released, then another user can acquire another lock (be it share or exclusive). If that happens and your transaction is undone, the undo will FAIL cuz of the conflicting lock. This is not a good situation. [/quote] Of course. The prior wording threw me for a bit of a loop.

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