Page 1 of 1

lock mysql table

Posted: Sun 13 Feb 2005 11:44
by kstay
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.

Posted: Mon 14 Feb 2005 13:59
by Ikar
Most probably, you use FetchAll = False

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