.Update Method with ADO Recordsets
Posted on 2000-05-11
I have a problem using the .Update method with and ADO recordset using
Oracle and VB 6.
I have a loop to go through each text box and assign each one to a field in the database.
Rs.Fields(val).value = Text(i).text.
if there is a numeric value I set it to NULL and string values I set to ""
This is fine with the first update but if I change the data and try to save
the record again using the .Update Method. I get the following error message from VB.
Err.Number = -2147217864
Err.Description = The specified row could not be located for updating.Some
values may have been changed since it was last read.
Could anyone explain what the cause of this error and any way to fix or go around it.