glenndetollenaere wrote:

>
> an "explicit" lock (or pessimistic lock):
>
> SELECT * FROM {table} WHERE {whereclause} WITH LOCK;
>
> prevents the record from being changed by other users at the same time
> (getting a lock conflict-message, which is ok).
>
> If the PC is turned off however, this LOCK remains on the serverside,
> so the only way to "free" the record is by restarting the FireBird server.

What FB architecture do you use: SuperServer or Classic Server?


Dmitry