Page 1 of 1

Exception: Update failed. Found 0 records

Posted: Mon 24 Jan 2005 14:48
by 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

Re: Exception: Update failed. Found 0 records

Posted: Mon 24 Jan 2005 14:54
by 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.

Posted: Tue 25 Jan 2005 12:55
by 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.

:o