Migrating from MyDac to UniDac : how to lock a table ?

[swierzbicki]

Hello,

LockTable is missing from TUniTable/TUniQuery !
How can I lock a table with UniDAC ?

[AndreyZ]

Hello,

To lock a table or tables, you should use the following code:

Code: Select all

UniConnection.ExecSQL('LOCK TABLES tablename READ',[]);

To unlock tables, you should use the following code:

Code: Select all

UniConnection.ExecSQL('UNLOCK TABLES ',[]);

For more information, please refer to http://dev.mysql.com/doc/refman/5.0/en/lock-tables.html

[swierzbicki]

Thank you !