lock mysql table

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply

lock mysql table

Post by kstay » Sun 13 Feb 2005 11:44

I have execute an sql statement to lock table `parameter`.

lock tables parameter read;

I try to update this table records example :

update parameter set vers='1.35';

System seems hang. It only able to function after I unlock the tables.

Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Mon 14 Feb 2005 13:59

Most probably, you use FetchAll = False

Suppose, you should pay attention to TCustomMyDataSet.LockTable method.

Post Reply