Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Updation error

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-18 : 08:11:48
Santosh writes "i am not sure that this question is asked to sql team or not but...

When i am updating the Record A, for the first time it is not giving any error, But when i try to update the same record again it is giving error, details are as follows:

1. err. number: -2147217864
2. err. description: 'Row cannot be located for updating. Some values may have been changed since it was last read'

I am trying to update the record from VB, using record set object. Locktype: adLockBatchOptimistic and using 'UpdateBatch' method with option as 'adAffectAllChapters'

santosh"
   

- Advertisement -