Thanks for your reply Sergey! I was looking for a way to validate the business rules in the server but then I realized it'd be a design error because if anything fails I'll have to send the data back to the server again so I prefer to validate before connecting to the database.

Enmanuel


>You'll have to analyze connection Errors collection.
>

>FOR Each loErr IN loCon.Errors
>  * loErr.Description, loErr.Number
>ENDFOR
>

>>Hi all, I've a table with several check constraints and I'd like to know if there's a way to know exactly what constraint was broken (if that's the case). For example If I have CK_CreditLimit Constraint where the ammount for the field must be >=0, if I try to insert a negative value the constraint is triggered but how can I know back in my Data Layer that this specific check was broken.
>>
>>I'm using ADO to connect to the database.
>>