Information générale
Catégorie:
COM/DCOM et OLE Automation
The last constraint I tested this with was in a varchar field (length 1) only allowing the letter 'A' in to the table. I know the constraint is firing because the error -2147217873 is a constraint error. Thanks for the pointer to the cursortype. I have changed this to KeySet with no difference. Could I see the changes you made. This may sort the problem
Thanks Again
Gerry
>What is the constraint on the fields? I ask this because the error might not be related to field constraints. Check in what line the code is raising the error.
>
>Another thing I notice is that you should have a static or keyset cursor for batch updates, as explained in the help for the UpdateBatch method. The way you have your code you are opening a forward only cursor.
>
>I tested some of your code and after adding the appropriate cursor type setting before opening the RS the status field does return the corresponding constant.
>
>>>>In further inspection, the Status property does get populated in this circumstance. This property should return 11 (adFieldSchemaViolation) for the offending field object.
>>>>
>>>>Can you post more details as to how you are checking the status field?
>>>
>>>I mean status property.
>>
Précédent
Suivant
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