Printable View
what does the following message mean and how to sovle the
problem?
“the specified row could not be located for updating, some values
may have been changed since it was last read”
error number is -2147217864
I used the ado data control to connect the sql server table
in the vb. I used the adodc1.recordset.updatebatch to update the table. the cursorlocation is at the client site
cursor type is static
Please hellllllllp! Thanks a lot.
I've never seen the specific message but it sounds like you've displayed a set of records from a database (like a grid for example) but by the time the user has gone to select a record it has been deleted or it has been changed in such a way it is not in the same place in the recordset as it was when you first displayed it.
Or you may have opened a recordset to do some work on it, and by the time you've gone to update it it has been changed or deleted by someone else.
Im not sure if this will work, but maybe u can try changing the cursor type from static, coz once the recordset is opened as static any changes/deletion made by other users will not be visible to u.
hope it helps.