Consultor Eletrônico



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.