Samir,
ISRLOCKED() only checks if you have a record locked. To check if another use has it locked, you have to try and lock the record yourself using the RLOCK() function. You can check the return value; if .T., no one else had it locked and you got a lock.
HTH.
>Hi,
>
>How can I find the lock status of the record in a multi user environment.
>
>I mean, when a user is editing a record at the same time, another user should not be able to edit the same record and a message should be displayed on his workstation that the record is locked for editing by another user.
>
>I tried using ISRLOCKED() function, but it is not solving the purpose. The BufferMode property of the form is set to 1-Pessimistic and Datasession is set to 0-Default.
>
>I am using VFP 7 for making the exe.
>
>Any ideas on this will be very helpful.
>
>TIA.
>
>Regards,
>Samir.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao