>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

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?