[DUG] Connection to MySQL using Devart

Graham Marsden graham at wk.planet.gen.nz
Wed May 9 13:08:24 NZST 2012


Hi Wallace

Yes I have seen this behaviour as well, which responds to the addition of an index.
I usually anticipate this and add a a field to the MySQL table as outo-increment integer as the primary index.

I think the problem stems from the fact that in some contexts, like only some of the fields are in the app's querey, 
the records the app sees in the dataset extracted by the Devart queri eare not unique enough when the instruction 
to delete/update is reinterpreted by MySQL.

HTH

Graham Marsden




More information about the Delphi mailing list