Kbase P46542: Dynamics: launch.i leaves records locked
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/10/2003 |
|
Status: Unverified
FACT(s) (Environment):
Dynamics 2.0A
SYMPTOM(s):
Dynamics: launch.i leaves records locked.
This happens both with direct connections to the database and with Appserver.
CAUSE:
Record Locking problem within the code.
FIX:
Instead of locking the database table and updating it directly, define a buffer for the table and update the buffer. It is important to only use the buffer record for updates, so that the record scope is not extended.
e.g.
DEFINE BUFFER b_order FOR order.
DO TRANSACTION:
FIND FIRST b_order EXCLUSIVE-LOCK.
/* Update b_order record */
RELEASE b_order.
END.