>>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()
For rows that are already locked by someone else, RLOCK() will return .F.
So, shouldn't you be doing COUNT FOR NOT RLOCK() instead?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up