Page 1 of 1
Lock Firebird table
Posted: Tue 05 Aug 2014 19:28
by testpresta
Hello
I want to lock a full firebird table.
if two users are trying to execute the same code, i don t want the second user to wait. I want to put an error message to this user.
How should i do with unidac ?
Thanks
Re: Lock Firebird table
Posted: Wed 06 Aug 2014 19:23
by testpresta
Forget Firebird. I just want to know how lock a table with UniDac, whatever the database engine.
Thanks.
For example, it is possible to lock a table with this syntax on firebird when starting transaction:
Code: Select all
SET TRANSACTION NO WAIT RESERVING myTable FOR PROTECTED WRITE;
But i don t know how to give those options on TuniTransaction component
Thanks
Re: Lock Firebird table
Posted: Tue 12 Aug 2014 09:34
by PavloP
Currently, UniDAC does not support transaction start with table block for Firebird. You may suggest the feature implementation at
http://devart.uservoice.com/forums/1046 ... components.
Table block is specific for each Database servers, that are supported in UniDAC, that is why UniDAC does not include the single method for table block. To perform this task in UniDAC, you may use the "SELECT ... FOR UPDATE" и "SELECT ... WITH LOCK" commands. To learn more, refer to the official Firebird documentation.