Cannot be located for updating

Posted by / 29-Jan-2021 20:29

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.

cannot be located for updating-64cannot be located for updating-21cannot be located for updating-40

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.

One thought on “cannot be located for updating”

  1. Those butterflies of excited joy as you open the latest message from your new match, your first glimpse as you turn up for a date, a shared joke that only the two of you understand; these moments begin with eharmony.