Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ADO and Data Integrity Checks
Message
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
ADO and Data Integrity Checks
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01209224
Message ID:
01209224
Vues:
63
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.

TIA,

Enmanuel
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform