Subject | Exclusive Lock |
---|---|
Author | Guillermo Najar-Arreola |
Post date | 2002-10-01T00:32:56Z |
Hi,
I have a process that must be done just if NO user is accesing any record on
a specific table. On my desktop application experience, this could be done
setting an exlusive-lock on that table. I know that Firebird 1.0 as other
SQL Servers, have an optimistic-lock scheme for multiuser acces.
How can I achieve this exlusive-lock in Firebird for a table? I'd like not
doing it from my application using flags that usually are not as solid as
any built-in mechanism on the DB Server.
Thank you,
Guillermo
I have a process that must be done just if NO user is accesing any record on
a specific table. On my desktop application experience, this could be done
setting an exlusive-lock on that table. I know that Firebird 1.0 as other
SQL Servers, have an optimistic-lock scheme for multiuser acces.
How can I achieve this exlusive-lock in Firebird for a table? I'd like not
doing it from my application using flags that usually are not as solid as
any built-in mechanism on the DB Server.
Thank you,
Guillermo