The clause FOR UPDATE WITH LOCK is designed to cause a persimistic lock of
record, but if your transaction have a parameter wait and the time of
transaction is very short your users don't see difference....



Julio Cesar
julio_gyn@...
ICQ: 149863922
Grafcenter Informática LTDA.
Sistemas de Gestão Comercial

----- Original Message -----
From: "Jean Derrie Rigo" <rigo@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, July 25, 2003 10:32 AM
Subject: [firebird-support] Select for update with lock


> 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]
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>