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.

Doru

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Kjell Rilbe
Sent: 31 iulie 2008 10:26
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] get_lock / release_lock

Doru Constantin wrote:

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

http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html#function

>

<http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html#functio
n>

> _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
means.

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

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

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

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

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