Subject Re: Lock conflict
Author glenndetollenaere
Hi Dmitry,

we use the Super Server binaries on Win XP / Vista.

regards,
Glenn

--- In firebird-support@yahoogroups.com, Dmitry Yemanov <dimitr@...>
wrote:
>
> 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
>