Page 1 of 1
Migrating from MyDac to UniDac : how to lock a table ?
Posted: Sat 17 Dec 2011 21:52
by swierzbicki
Hello,
LockTable is missing from TUniTable/TUniQuery !
How can I lock a table with UniDAC ?
Posted: Mon 19 Dec 2011 12:07
by 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
Posted: Mon 19 Dec 2011 20:32
by swierzbicki
Thank you !