At 01:48 PM 20-08-02 -0400, you wrote:

>I am use pessimistic locking, the problem that I have is that after to
>update record the user A the registry that always locked in the User B.
>
>That I am making bad?

The row will remain locked until user A's changes are committed or rolled
back.

If you are using explicit transaction control, Post does not commit.

Even if you are using AutoCommit, the lock will remain in force if the
Autocommit fails for any reason. Therefore, you must detect server errors
and, when an error occurs, roll back the transaction in order to release
the pessimistic locks.

Helen