This in the link to the my Sql online manual:
http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html#function
_get-lock

It is like a flag that can be seen by any user.

Doru

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Alexandre Benson
Smith
Sent: 31 iulie 2008 09:20
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] get_lock / release_lock

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


------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links