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