Yes, this is the intent. I am using this table to calculate number of users that are already in the system. When new user logged in they lock one record and this record stay locked until they exit the application. Next user will login the program will count number of locked records and lock the next available record.

>>Thank you Naomi and Hilmar.
>>
>>You are both correct, your code is much better, but in any case rlock() is where the user get stuck.
>
>Are you doing UNLOCK later in the code? You locked the record and keep it locked. Is it the intent?