Subject Re: [firebird-support] Re: Lock conflict
Author Dmitry Yemanov
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?