Kbase 19800: Getting Error 2624 with a FIND Statement
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/02/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
SYMPTOM(s):
Getting Error 2624 with a FIND Statement
<file-name> in use by <user> on <tty>. Wait or choose CANCEL to stop. (2624)
No records are expected to be locked.
CAUSE:
This is expected behavior. The reason why the second user sees the message is that the FIND statement in the code does a full table scan.
FIX:
Change the code so that the user 2 reads records with NO-LOCK.
After user 2 finds the correct one, re-read it with the correct type of lock using FIND CURRENT statement.