Cannot be located for updating
I know this has to do with ADO trying to locate a row by specifying each field it knows about, as in "select * from customer where [Name]="Me" and [Address]="Someplace" and so on for each field. In my application, I use a t Ado Data Set with a simple Command Text like "select * from Customer".However, my table has a primary key defined and rows can be uniquely identified using this key (an Int). Recently added an insert/update trigger to a table in SQL Server to populate some fields from a 2nd table.
EDatabase Error--Row cannot be located for updating.I'm working with Delphi (XE3) and need to connect to a My SQL database. I'm having a strange problem that seems quite common but I still haven't entirely solved this problem. The returned message is "Row cannot be located for updating.Some values may have been changed since it was last read. It put only some default values on other not rilevant columns.
Some values may have been changed since it was last read ******ADO Errors******* *Error Number: -2147217864 * *Source: Microsoft Cursor Engine *Description: Row cannot be located for updating.