>>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?

I mean status property.