Exception: Update failed. Found 0 records

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Hanne Berthelsen
Posts: 15
Joined: Thu 18 Nov 2004 07:51

Exception: Update failed. Found 0 records

Post by 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

Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Re: Exception: Update failed. Found 0 records

Post by 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: 43
Joined: Mon 15 Nov 2004 08:48
Location: Malaysia

Post by 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.


Post Reply