Row cannot be located for updating ez passion internet dating service
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.
This occurs since first option in DSN config ("Return Matching Rows") is not checked even we say clearly it should be in manual.What causes this error and how can I handle it in my exception handling.EDatabase Error--Row cannot be located for updating.If it was, My SQL server would return "found_rows" (1 ) instead of "affected_rows" (0).Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.
If you dont have a primary key, then the db manager tries to figure out which row should be updated by seeing if he can find one that looks much like the one that you just changed in the query object. I am not able to reproduce it, although it occurs most often when I am trying to delete a record. The error message you are getting indicates that ADO can't find the record to be deleted.