Doru Constantin wrote:

> How can I simulate mySql get_lock / release_lock in firebirdSql?
>
> Thank you.
>
>
>
> Doru
>

I don't know what get_lock/release_lock do... it's a kind of pessimistic
record locking ?

if so... my first question is.. Do you really want to do this ???

If so... use select for update, or do a dummy update on the record, to
prevent it to be updated by another transaction.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br