Exception: Update failed. Found 0 records

Exception: Update failed. Found 0 records

Postby Hanne Berthelsen » Mon 24 Jan 2005 14:48

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. and MySQL v. 4.1.8.
The error has happened for both an InnoDB and an MyISAM table.

Regards Hanne
Hanne Berthelsen
Posts: 15
Joined: Thu 18 Nov 2004 07:51

Re: Exception: Update failed. Found 0 records

Postby Ikar » Mon 24 Jan 2005 14:54

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.
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Postby kenny » Tue 25 Jan 2005 12:55

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.

Posts: 43
Joined: Mon 15 Nov 2004 08:48
Location: Malaysia

Return to MySQL Data Access Components