>>>>BTW, I could not find how to add TABLE validation rule.
>>>
>>>Prepare a simple DB with all procedures you wan. Then use GENDBC and check what code it generates :-)
>>
>>I found the table validation rules, BTW: (in How to: Create Record Validation Rules topic)
>>
>>ALTER TABLE Employee SET CHECK Hire_Date >= birth_date + (18 * 365.25) ;
>> ERROR "Employees must be 18 years or older by date of hire."
>
>I don't know if there is TABLE validation rule. They are always Record Validation rules :-)
Good catch! :) Tx.
If it's not broken, fix it until it is.
My Blog