Problem in Editing the Record in Batch Update mode ADODB.RescordSet 
Author Message
 Problem in Editing the Record in Batch Update mode ADODB.RescordSet

Hello all

I have 1000 records in a RECORDSET object which opened in a mode of
adLockBatchOptimistic. Since i wanted to post the changes to database in
a single hit by calling the RECORDSET.UPDATEBATCH method. Once i opened
the recordset, i am finding for a particular record and successfully
found and i am editing the same record by changign the values. And again
i am finding for a particular record and that also successfully found.
BUT WHEN I AM TRYING TO EDIT THE FOUND RECORD. i am getting this below
error. i reference the MSDN, but no use.

Error Number :-2147217836
Error Message :Number of rows with pending changes exceeded the limit.

Please kindly help me out in this. Its quiet urgent.

Thanks in advance
shankar.

*** Sent via Developersdex http://www.*-*-*.com/ ***
Don't just participate in USENET...get rewarded for it!



Sat, 26 Jun 2004 22:29:58 GMT  
 Problem in Editing the Record in Batch Update mode ADODB.RescordSet

Are you using client-side cursors?  If not, your database server may be
throwing the error.  It this is the case, then simply use the client
side cursor, disconnect the recordset, make the changes, reconnect and
do the UpdateBatch.  That should take care of the problem.  If not, post
the code and let us take a look.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Sun, 27 Jun 2004 04:30:05 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Problem in Editing the Record in Batch Update mode ADODB.RescordSet

2. Problem in Batch Update on ADODB.RescordSet

3. Problem with Updating in Batch Mode

4. Batch edit/update hyperlinks?

5. Edit Custom Properties via ADODB.Record

6. Batch Updating records in MS-Access

7. Batch updating values in one field for all records

8. Update records in batch

9. typical code for displaying and editing records from database table(s) in a grid in unbound mode

10. ***** Cannot update database, rescordset via RDS *****

11. ***** Cannot update database, rescordset via RDS *****

12. Programatically changing Form from Data Entry mode to Edit mode

 

 
Powered by phpBB® Forum Software