[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Table locking?

  • Thread starter Thread starter Thomas Mercer-Hursh
  • Start date Start date
Status
Not open for further replies.
T

Thomas Mercer-Hursh

Guest
To expand on what Tim has said ... if you do a FOR EACH NO-LOCK and then, having found the record, then refind the record exclusive lock, then you will only ever lock one record. But, if you do a FOR EACH EXCLUSIVE-LOCK and the criteria are such that it has to read a lot of records until it finds the one which fits all criteria, i.e., there is no index which supports going to the record directly, then it will lock all the records it has to read while doing the search until it fnds the exact record.

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