Information générale
Catégorie:
COM/DCOM et OLE Automation
Titre:
Constraint Error Handling with ADO and SQL
Hi,
I hope someone can help me with a problem on ADO2.6 and SQL Server 7. I have a field Constraint on a SQL Table (field may not be empty). When I write a new record via ADO to the Table with empty fields, I can capture the error in the connection Error collection object OK. But I want to be able to find out which field caused the constraint error to fire. I thought I could examine the status property of each field in the recordset, but this property does not seem to be updated at this stage.
I am going about the problem the right way. Is there some other way of approaching this problem. Any help would be greatly appreciated
TIA
Gerry McDermott
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