Remember though that those only show if the running copy of the program has a lock. If you need to find out if someone else has it lock the ONLY way is to attempt to lock the record yourself.


>Wow, How did I miss that for all these years???
>
>Thanks to both of you!
>
>Rick
>---------------------------------------------------------
>>Jim got the answer, just to add take a looka at this taken from the help file
>>
>>SYS(2011) - Current Lock Status
>>See Also
>>FLOCK( ) | LOCK( ) | RLOCK( ) | SYS( ) Functions Overview
>>Returns the record or table lock status for the current work area.
>>
>>SYS(2011)
>>Return Values
>>Character
>>
>>Remarks
>>Unlike the FLOCK( ), LOCK( ), and RLOCK( ) functions, SYS(2011) doesn't attempt to lock the table or record.
>>
>>The character string returned by SYS(2011) is identical to the message displayed in the status bar (Exclusive, Record Unlocked, Record Locked ...).
>>
>>SYS(2011) returns Exclusive only at the workstation that opened the table exclusively, and Record Locked only at the workstation that applied the record lock.