Subject RE: [firebird-support] get_lock / release_lock
Author Doru Constantin
I have an old app: vfp + odbc + mysql.
I try to replace mysql with minimal change in code.

In this app when a user is add/modify/delete a document the get_lock()
function is called and if the lock is get then the user can continue
otherwise don't.

I read about RDB$SET_CONTEXT / RDB$GET_CONTEXT, but "... variables may be
read and written to and by whom are determined by namespace which they
belong to.".

I need RDB$SET_CONTEXT / RDB$GET_CONTEXT but in a global context.


-----Original Message-----
[] On Behalf Of Kjell Rilbe
Sent: 31 iulie 2008 10:26
Subject: Re: [firebird-support] get_lock / release_lock

Doru Constantin wrote:

> This in the link to the my Sql online manual:

> _get-lock
> It is like a flag that can be seen by any user.

Doru, if you explain what purposes you intend to use it for, this
community will stand a better chance to help you.

I understand get_lock as a kind of server-global transaction independent
named mutex. My immediate reaction is that it's a feature that does not
belong in a DB server, but should by preference be implemented by other

So, what is the problem you're actually trying to solve?

Kjell Rilbe
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64



Visit and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at

Yahoo! Groups Links