Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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
Is N_OFF_ID a field marked as a primary key? These fields are usually marked as read-only on disconnected recordsets.
I would check the value of the Status property for this field (and all fields if the Status for this one is 0) to see what the problem is. If a constraint error is the problem this property will tell you exactly what is wrong.
Also, check the errors collection on the connection object, if there is one open at the time associated with the recordset.
HTH
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement