>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
You may want to read the "Programming for Shared Access." Scope of lock was clearly discussed there.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."