After migrating a project to Delphi 11.2 + MySQL 5.0 + Zeos 8.0 I noticed other strange behavior that did not occur previously in the 7.1.4-stable version of Zeos used in Delphi 2010.
To make it easier, I reproduced the problem in a simple scenario.
Project Delphi: https://mega.nz/file/PBM3XYJb#tVaTqSJGQ ... 3mTPg76ZZE
Script SQL: https://mega.nz/file/ectDCYST#GKyfpOq64 ... LIBAIGMdc0
I created a new VCL project with just one form and the components below:
I also created a test2 database with just one table named tbl_test2.
I also put some rows in the table for the example.
ZQuery1 is linked to the tbl_test2 table, DataSource1 is linked to ZQuery1, ZQuery1 is pointed to ZUpdateSQL1 to execute the DML commands and DBEdit1 pointed to DataSource1, field name. A normal scenario.
In the Append button I execute ZQuery1.Append, in the Delete button I execute ZQuery1.Delete and in the Post button I execute two commands:
Code: Select all
ZQuery1.Post;
ZQuery1.Refresh;
This behavior happened only in the new Zeos 8.0 + Delphi 11.2 scenario.
Can anybody help me?
Thx