>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()
If it's not broken, fix it until it is.
My Blog