Kbase P24620: Changes made to a database record by one user are not seen by another user.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/04/2009 |
|
Status: Verified
SYMPTOM(s):
Changes made to a record by one user are not seen by another user.
The second user is fetching the record by executing a SECOND FIND with NO-LOCK.
CAUSE:
The second FIND uses the 'old' record copy in the local buffer and does not re-read the modified record from the database.
FIX:
Either release all the buffers held by the user doing the latest modifications to the record or make the second FIND a with a SHARE-LOCK or EXCLUSIVE-LOCK to force a re-read of the latest available copy of the record.