Subject Re: [firebird-support] Re: Select for update with lock
Author Jean Derrie Rigo
You are rigth... The IBConsole don't do, and the IBExpert don't do too...

I test on two connections with the ISQL and the behaviour is the expected!!!
Now i need to know what component's for Delphi 7 will support this...

Thanks for the help.

Jean Derrie Rigo

----- Original Message -----
From: Alexander V.Nevsky
Sent: Friday, July 25, 2003 12:30 PM
Subject: [firebird-support] Re: Select for update with lock

--- In, "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

Best regards, Alexander.

Yahoo! Groups Sponsor

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Non-text portions of this message have been removed]