banzatto@... wrote:

>CREATE TRIGGER AREA_BI0 FOR AREA
>...
> > > WHERE (A.DIVISAO1 = NEW.DIVISAO1)
> > > AND (A.DIVISAO2 = NEW.DIVISAO2)
> > > AND (A.DIVISAO3 = NEW.DIVISAO3)
> > > AND (A.DIVISAO4 = NEW.DIVISAO4)))
> > > THEN
> > > EXCEPTION CHAVE_DUPLICADA;
>
>The fields DIVISAO1, DIVISAO2, DIVISAO3, DIVISAO4 cannot have to be
>duplicate, but they can have null values , therefore the use of
>trigger. Only that to trigger she does not function. Why ?

If one of those fields has a null value in either table, then your
boolean expression evaluates to false. To make this work, you'll
need to add code to handle the null case.

>CREATE TRIGGER AREA_BI0 FOR AREA
>...
> > > WHERE (A.DIVISAO1 = NEW.DIVISAO1

OR A.DIVISAO1 IS NULL AND NEW.DIVISAO1 IS
NULL)

> > > AND (A.DIVISAO2 = NEW.DIVISAO2

OR A.DIVISAO2 IS NULL AND NEW.DIVISAO2 IS
NULL)

> > > AND (A.DIVISAO3 = NEW.DIVISAO3

OR A.DIVISAO3 IS NULL AND NEW.DIVISAO3 IS
NULL)

> > > AND (A.DIVISAO4 = NEW.DIVISAO4

OR A.DIVISAO4 IS NULL AND NEW.DIVISAO4 IS
NULL)))

> > > THEN
> > > EXCEPTION CHAVE_DUPLICADA;

Regards,

Ann
www.ibphoenix.com
We have answers.


Please, next time, don't shout bug until you're more certain you've got a bug.
It upset me.