Hello i'm a delphi developer and i'm using your components on my RealRally manager project.
I'm writing a recovery routine to execute the logged query into a file.
What i don't understand is this thing:
I first do an update before an insert to know the status of that operation
Using sqlyog i see if an update return 0 (no rows updated) or 1 (one row updated).
based on that result is really easy know if i need to skip the insert query.
There is a way to know what appen after executing a query from tzquery?
i will try to be more clear with this example:
ZQuery1.SQL.Clear;
ZQuery1.SQL.Add(Encrypt(Data[y], '1')); // the string can be something like: UPDATE startlist Set Damage = 1 WHERE IdPilota = "vcorp" AND IdRally = "00000000000446";
ZQuery1.ExecSQL;
I need to know after ExecSQL what happened
if there are some row updated or 0 row are updated.
Thanks for your Help, the version is 7.2