Re: Check constraint violated

On Sat, 14 Jun 2003 13:09:53 +0000, andrewst wrote:  

>Originally posted by andrewst
>> ALTER TABLE appointee
>> ADD CONSTRAINT chk_nominee_age CHECK (age < 18);
>Of course, Age is a rather silly column to hold in a table, because it
>is meaningless by itself. Without knowing the date when the Age value
>was entered/updated, it tells you only the the person is "at least" 17
>(e.g.); by now he.she could be 18, 19, 42, ... What you should really
>hold is date of birth (or year of birth or whatever suits your needs).
 

But the date on which the proposal was submitted has been stored in PROP_POLICY_DATA->PROP_DATE   Moreover it is the age of the proposer at the time submitting the proposal that is crucial. Then the policy may be alloted for a period of 5 or 10 years during which the actual age of the proposer is immeterial.  

If you have any other suggestions please mail them to me.  

You can also see the form:
http://www.licindia.com/lichome2/300(bn).doc  

Thanks a lot.

-- 
I had sent you a mail but it bounced back.
Please answer this post by mail rather than answering it in the group if it's ok
with you.
Thanks.