Kbase P8126: Do all records accessed in a FOR EACH...EXCLUSIVE-LOCK loop
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/02/2003 |
|
Status: Unverified
GOAL:
Do all records accessed in a FOR EACH...EXCLUSIVE-LOCK loop remain locked until the loop terminates?
FIX:
No, if the FOR EACH block is not a part of a wider transaction, only the record(s) of the current iteration are locked. Once the FOR EACH loop moves to the next iteration all previously locked records are released.