Great, if only I can figure out why RLOCK() get stuck :)



>>While LOCATE FOR will work I need to count number of records that already locked to know how many active users are in the system. The file will never be too big, I think max number of users any of our clients have is 100 right now. Also I am using FOR.. NEXT loop because in case number of locked record reached maximum number of users I want to stop checking no matter how many records are in the table.
>>
>COUNT FOR RLOCK() to AlreadyLoggedUsers will work the same way as LOCATE FOR RLOCK()