When I'm trying to update information in the database vb6 is fetching me the following error:-

"Row cannot be located for updating.
Some values may have been changed since it was last read."

what is the cause and remedies for the above error?

9 Years
Discussion Span
Last Post by sandeep_chalke

The reason for the error may be because the WHERE clause in the SELECT statement used
to create the recordset does not contain a primary key column. Therefore, when ADO
generates the UPDATE statement for the Update method, it cannot not use key column
information. Thus, the Update statement was not able to identify one particular
row to update.

The solution is to create your own UPDATE statements to include the key
column(s) and execute them using the EXECUTE method.

Let me know if this helps. Also, which database are you using?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.