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:30:00 GMT
 Problem in Editing the Record in Batch Update mode ADODB.RescordSet

Hi,

It looks like you have next problem

http://support.microsoft.com/default.aspx?scid=kb;EN-
US;q261297

Val

Quote:
>-----Original Message-----

>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.developersdex.com
***
>Don't just participate in USENET...get rewarded for it!
>.



Sat, 26 Jun 2004 22:44:50 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Batch Mode, But Not Batch Mode

2. Problem with Updating in Batch Mode

3. Examining a deleted record in a batch update record set

4. Help using batch update mode

5. Enter form in edit mode and new record??

6. Help! Record locked - Not in Edit Mode

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

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

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

10. Jet 3.5 Edit mode or AddNew mode

11. Creating adodb.record from Adodb.recordset

12. Help to update & create record by batch


 
Powered by phpBB® Forum Software