Kbase P88711: How to cause each record in a FOR EACH to be its own transaction?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
31/08/2004 |
|
Status: Unverified
GOAL:
How to cause each record in a FOR EACH to be its own transaction?
FIX:
To cause each iteration to of a FOR EACH statement to be its own transaction (i.e. there is no active transaction prior to the FOR EACH and you want to code inside the FOR EACH to start and stop a transaction) do the following:
FOR EACH TableName NO-LOCK:
DO TRANSACTION:
FIND CURRENT TableName EXCLUSIVE-LOCK.
... Apply Changes To The Record Here ...
END.
END.