Subject | RE: [ib-support] Re: OR in TRIGGERS |
---|---|
Author | Dmitry Yemanov |
Post date | 2002-10-25T07:04:09Z |
Ryan,
IF (old.SOMEVAL <> new.SOMEVAL OR
old.SOMEOTHERVAL <> new.SOMEOTHER VAL) THEN
...
or
IF ((old.SOMEVAL <> new.SOMEVAL) OR
(old.SOMEOTHERVAL <> new.SOMEOTHER VAL)) THEN
...
Dmitry
> Can you use 'OR', or some other kind of syntax which is equivalentYes, you can.
> to an OR condition, in triggers?
> i.e.,Use either:
>
> IF (old.SOMEVAL <> new.SOMEVAL) OR
> (old.SOMEOTHERVAL <> new.SOMEOTHER VAL) THEN
> ...
> ...
>
> I'm getting an error 'Token Unknown - OR'
IF (old.SOMEVAL <> new.SOMEVAL OR
old.SOMEOTHERVAL <> new.SOMEOTHER VAL) THEN
...
or
IF ((old.SOMEVAL <> new.SOMEVAL) OR
(old.SOMEOTHERVAL <> new.SOMEOTHER VAL)) THEN
...
Dmitry