I'm supporting a FPW 2.6 program which has the following line of code

DELETE WHILE agentcode=m.agentcode and ctrl_num=m.ctrl_num

When executing this line I get the message

"Attempting to Lock.......Press ESC to cancel" which stayed until I pressed ESC

There were two other users in the system who were using the file. Neither of them were on this particular record. The WHILE clause meant that only this record would have been deleted.

Adding a scope of

NEXT or
NEXT 10

didn't help. The message remained. Adding a scope of NEXT 1, however, let the line execute. Removing the WHILE clause so that it would work on just the one record also worked.

There are several tags on the file - none of them include DELETED() however.

Can anyone provide some information as to what Locks are attempted and why they fail in this environment??

TIA...........Rich