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;

and there is no lock on the records... It's just cause deadlock if I try to
update banco_movimento...

How can I lock the records on the select statement... I was thinking that is the
select for update with lock that's do it...

ps..: sorry about the english...
---------------------------------------------------------
Jean Derrie Rigo
rigo@...
---------------------------------------------------------


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