Subject Re: Select for update with lock
Author Alexander V.Nevsky
--- In firebird-support@yahoogroups.com, "Jean Derrie Rigo"
<rigo@f...> wrote:
> I'm using Firebird 1.5 RC4. Dialect 3.
> Windows 2000 Service Pack 4.
>
> I do on ISQL:
> select * from banco_movimento for update with lock;
>
> then I try the same on IBConsole:
> select * from banco_movimento for update with lock;

Jean, IBConsole is based on IBX and together with them don't support
Select for update, even without lock. AFAIK IBExpert, which is based
on very old FIBPlus, process this statement incorrectly too, FIBPlus
support it since version 5.0 only. I'll contact Alexander Khvastunov
soon to force improvement of IBExpert, don't think it reqiures much
time.

Best regards, Alexander.