General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
ADO: strange error?!?
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only