Search found 1 match
- 07.07.2011, 22:42
- Forum: 6.6 - stable
- Topic: ExecSQL doesn't commit
- Replies: 1
- Views: 533
ExecSQL doesn't commit
Lazarus v 0.9.29 MySQL 5 I have the ZConnection component set to autocommit. I have Zquery component named query 1. My code looks like this sql := 'UPDATE GRADELINK SET PROVFLAG = 2 WHERE GRADEID = ''104312245|IWAY|10417'''; with query1 do begin Active:=False; SQL.Clear; SQL.Add(sql); ExecSQL; end; ...