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?
choudhuryshouvi 33 Posting Pro
sandeep_chalke 0 Newbie Poster
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?
choudhuryshouvi 33 Posting Pro
Sir I'm using Oracle9i database.
sandeep_chalke 0 Newbie Poster
Did you get a chance to try the solution I mentioned.
In addition please refer the following link-
http://support.microsoft.com/?id=258997
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.