Exception: Update failed. Found 0 records

[Hanne Berthelsen]

Does anybody know what is wrong with a table if you get the exception "Update Failed. Found 0 records" when using MyTable->Post() ?

I am using MyDAC v. 3.30.2.15 and MySQL v. 4.1.8.
The error has happened for both an InnoDB and an MyISAM table.

Regards Hanne

[Ikar]

This error happens if none of records was updated - no record suits for UPDATE clause or no field was modified. You can turn off this message. Please refer to help TCustomMyDataSet.Options.StrictUpdate.

[kenny]

Hi,
I'd experienced this error before also.
That's when your table no primary key, then you used table.edit then table.post will occur the error as you state. Delete on no primary key table also will cause this error.