lock mysql table

kstay · 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.

Ikar · Post by **Ikar** » Mon 14 Feb 2005 13:59

Most probably, you use FetchAll = False

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