Lock Firebird table

[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

[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

[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.