At 12:27 PM 6/12/2004 +0200, you wrote:

>... where some user cancelled a query abnormaly, next time user connecting,
>appears an error such as "record locked by another user".
>Environment ;
>Win2000 Server
>FB Super Server 1.5 (last stable ver.)
>Delphi 7
>FIB Components

That's normal, as-designed behaviour. If the application doesn't get the
chance to commit or cancel pending inserts, updates or deletes, because the
user uses the 3-finger salute, it will be approximately 10 minutes before
the server detects that the connection is gone for good and will flag the
transaction as rolled back.

So - if your user flashes up a fresh instance of the client application
straight away, and tries to do something to the same rows that s/he left
behind, s/he will find them locked until the server has done this detection
and cleanup.

./hb