Re: How to avoid 2nd trigger

by "lenygold via DBMonster.com" <u41482@[EMAIL PROTECTED] > Jul 14, 2008 at 03:02 PM

Thank you Lennart.
I like this approach.
One more question. What if  you  a manager or superviser then commissions
always should be zero and education level more then 10.

Lennart wrote:
>> How can i use declarative constraints for relarional edits?
>> For exam[le date of bitrh should always less than date of hire?
>
>ALTER TABLE EMP_SCREEN_EDIT ADD CONSTRAINT <NAME>
>    CHECK ( BIRTHDATE < HIREDATE )
>
>/Lennart
>
>[...]

-- 
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums.aspx/ibm-db2/200807/1

11 Posts in Topic:

How to avoid 2nd trigger

"lenygold via DBMons

2008-07-13 22:07:01

Re: How to avoid 2nd trigger

Lennart <Erik.Lennart.

2008-07-14 00:00:13

Re: How to avoid 2nd trigger

"lenygold via DBMons

2008-07-14 11:05:57

Re: How to avoid 2nd trigger

Lennart <Erik.Lennart.