Search results for query: *

Dear jnicho02 and Robert, I am aware of constraints but in this way you must assign more than one constraint per field (or Table). I have defined a User Defined Data Type and gave to it a Default Value. I want to bind this to a rule which i want to contain Default values. This is why i am...

Hi to all, I wonder if there is a way to use the default values i create to a rule. For example if i define two default values to describe the status of an order (Order_Pending & Order_Served) can i use these values in a rule which will check that the status of the order will have only these...

Hi Robert, unfortunatelly i have already look the @@error. I will use ADO collection to do this job. Thank you anyway.

Hi Robert, I have already try this. I am using VB as the client and i am connecting to SQL Server using ADO. Yes it is true somewhere inside the collections and properties of ADO i can find the error during constraint violation but with a different error code than SQL Server. When it comes to PK...

Hi to all, I want to find a way to get on runtime which constraint is activated. Suppose i want to insert some values into a table which doesn't allow nulls. I want to know which contraint(on which field) is activated and if this is written somewhere on the system tables in the MS SQL Server...