Zeoslib Portal

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;


The code runs fine, but it doesn't update the table. It looks like it is not committing the query.

Does anyone have any ideas?

Have you checked the RowsAffected property afterwards?