T
Thomas Mercer-Hursh
Guest
In ABL, you can't do anything other than lock an individual record ... with one exception. I don't know if this is still true, but it used to be the case that if you did a FOR EACH EXCLUSIVE-LOCK with a WHERE clause that eliminated large numbers of records, it would lock all the records it skipped while it looked for one that qualified. This was ***many*** years ago and I never see it any more since I would always do the outer loop no-lock and then reread the selected record exclusive lock. I suspect there must be something behind this question that you haven't told us, so perhaps it would help if you explained a bit more.
Continue reading...
Continue reading...