Cannot be located for updating brittany daniel is dating keenen ivory wayans
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.
*Native Error: 32 *SQL State : Thanks, Bill N Bill, Another process could have changed a value that the DB manager is using to locate the row. Value := ad Criteria Key; ad Criteria Key is defined in ADOInt. If your table don't have a primary key make sure u fill every single field with a value instead of NULL (I'm not sure whether this is a correct approach, but at least it work for me). I' using Delphi 7 with ADO components with an Access database. Is there a way to set the SQL generation to just use the key? I delete one record and when I reopen my app I find that two have been deleted instead. "Brian Bushay Team B" When you use clientside cursors and make changes or delete a record in the client ADO needs to Generate SQL to update (or delete) the Record in your database.
2004-01-06 AM delphi88 First of all best wishes to everyone. In my application, I use a t Ado Data Set with a simple Command Text like "select * from Customer".
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.
Some values may have been changed since it was last read.
However, my table has a primary key defined and rows can be uniquely identified using this key (an Int).
I've read some time ago in this NG (I believe) that you can limit the ADO where statement construct by informing the ADO recordset about this primary key (or rather: dropping the other fields). Presumably the trigger's you've added are connected to the table you Hi Brian, thanks for taking the time to answer.