AFAIK, Interbase/Firebird DON'T make pessimistic locking. The for update
is only used with CURSOR inside triggers and procedures. See Interbase
6.0 Guide:

"FOR UPDATE Specifies columns listed after the SELECT clause of a DECLARE
CURSOR statement that can be updated using a WHERE CURRENT OF clause"

--

*__________________________________________________________________*
*Marcos Vinicius Dufloth*
*ICQ#: 128291190

Tecnocyber, Ltda
Erechim - RS - Brasil
*

*+* *Outras formas de contato * <http://wwp.icq.com/128291190>
*__________________________________________________________________*



Jean Derrie Rigo wrote:

>Tanks for the attention...
>---------------------------------------------------------
>Saudações,
>Jean Derrie Rigo
>rigo@...
>---------------------------------------------------------
>
> ----- Original Message -----
> From: Serg Vostrikov
> To: Jean Derrie Rigo
> Sent: Friday, July 25, 2003 5:56 PM
> Subject: Re[2]: [firebird-support] Re: Select for update with lock
>
>
> Dear Jean,
>
> Friday, July 25, 2003, 8:05:30 PM, you wrote:
>
> JDR> I test on two connections with the ISQL and the behaviour is the expected!!!
> JDR> Now i need to know what component's for Delphi 7 will support this...
>
> FIBPlus certainly will support this. Actually, this feature is _already_
> supported, but in FIBPlus 5.0 RC. This version is not published
> officially on our site but it is available for FIBPlus customers.
>
> --
> Sincerely yours,
> Serg
>
> Devrace - software for developers!
> __________________________________
> e-mail: sv@...
> url : http://www.devrace.com/, http://www.devrace.de/
> http://www.fibplus.net/, http://www.athlant.com/
>
>
> 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]
>
>
>
>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/
>
>
>
>
>
>

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