Kbase P79393: Getting Error 2624 with a FIND Statement
Autor |
  Progress Software Corporation - Progress |
Acesso |
  Público |
Publicação |
  8/19/2006 |
|
Status: Unverified
SYMPTOM(s):
Getting Error 2624 with a FIND Statement
<file-name> in use by <user> on <tty>. Wait or choose CANCEL to stop. (2624)
CAUSE:
This is an 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.