Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO: strange error?!?
Message
From
15/08/2001 08:45:57
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
ADO: strange error?!?
Miscellaneous
Thread ID:
00543986
Message ID:
00543986
Views:
50
Hi,

when stress testing my COM object writing data to a DBC through ADO, I encounter a strange and not amusing problem.
I get an exception error 0 from ADO with error code 1429 from VFP.
It happens after I issue an oRS.addnew("N_OFF_ID",oOff.lcOFFID) command where oOff is a custum class with about 130 properties
It sometimes happens when issueing an oRS.update statement but not much.
I never succeeded in finishing a loop of 1000 new records added to a table and most of the times not even 400 new records.
Sometimes it starts complaining about not being able to find a certain column in the table totally unknown to me.
Does anybody know whether I'm encountering a limitation of ADO or that some buffers need to be released after running the program?

regards,
Erwin
Next
Reply
Map
View

Click here to load this message in the networking platform