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
rigo@...
---------------------------------------------------------

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


--- 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.



Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



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


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