Vb6 datagrid row cannot be located for updating
Rob Macdonald It's all too easy to gloss over the details when it comes to ADOdetails such as how ADO sometimes adds fields to your query, marking them as "hidden" and for its own use.
In this article, Rob Macdonald shares his real-world experiences and explains the ins and outs of updating and deleting data from back-end databases.
but I seem to remember that you can get probems like this if no primary key is defined for the table or in the methods used to access it. I am using Visual Basic and Backend sql server 2005i am updating one row in the table system showing Run time error below Error Description: Row cannot be located for updating.Some values may have been changed since it was last read. Maybe you don't want to know exactly how ADO updates a database when you make changes through a recordset.
Maybe, that is, until you want to know why it doesn't seem to work in all circumstances (and how to correct this), or how ADO manages to simulate optimistic locking without holding onto any locks.
In this article I'll explain how ADO's client cursor service generates SQL statements for recordset updatesnot just for the usual "SELECT * FROM authors" query, but for real-life scenarios involving joins and common cases where you retrieve only columns from a table, rather than all (*) of them.