Binding a rule to a field.

[Zejtuni]

Hi,

I am trying to construct a rule that validates a field using a user-defined function.

is this possible ?

Regards

 

[dbomrrsm]

can you not use a constraint - example of :

CREATE TABLE cust_sample
    (
    cust_id                int        PRIMARY KEY,
    cust_name            char(50),
    cust_address            char(50),
    cust_credit_limit    money,
    CONSTRAINT chk_id CHECK (cust_id BETWEEN 0 and 10000 )
    )

[blue]DBomrrsm[/blue]

 

[hmckillop]

Do you want to validate the data prior to insert? or as the data is inserted?
If its the first, and you are using a stored proc, you can do whatever you want regarding validating.
It its the latter have a look at a trigger.

Can you give a more detailed explanation at what you want?

"I'm living so far beyond my income that we may almost be said to be living apart

 

[Zejtuni]

I want to validate the data before inserting.

The new DataType is of type "##:##" and I have a user-defined function that validates this data.

I want to be able to validate this data at database level (it can be done easily through code).

The actual problem started because there is no "time" datatype in the "hh:mm" format only, or am I wrong?

What is the simplest way to have such a column?