lock mysql table

lock mysql table

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

Postby Ikar » Mon 14 Feb 2005 13:59

Most probably, you use FetchAll = False

Suppose, you should pay attention to TCustomMyDataSet.LockTable method.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56


Return to MySQL Data Access Components