Re: How to avoid 2nd trigger

On Jul 14, 6:32 pm, Lennart <Erik.Lennart.Jons...@[EMAIL PROTECTED]
> wrote:
[...]
> ALTER TABLE EMP_SCREEN_EDIT ADD CONSTRAINT <NAME>
>     CHECK (  NOT ( JOB IN ('manager', 'superviser')) OR ( COMM = 0 AND
> EDLEVEL > 10 ) )
>

Perhaps I should have elaborated a bit more about this.

A => B is the same as NOT A OR B. In your case:

JOB IN ('manager', 'superviser') => ( COMM = 0 AND EDLEVEL > 10 )

can be rewritten as

(NOT JOB IN ('manager', 'superviser')) OR (COMM = 0 AND EDLEVEL > 10 )

/Lennart