Subject RE: [ib-support] Re: OR in TRIGGERS
Author Dmitry Yemanov
Ryan,

> Can you use 'OR', or some other kind of syntax which is equivalent
> to an OR condition, in triggers?

Yes, you can.

> i.e.,
>
> IF (old.SOMEVAL <> new.SOMEVAL) OR
> (old.SOMEOTHERVAL <> new.SOMEOTHER VAL) THEN
> ...
> ...
>
> I'm getting an error 'Token Unknown - OR'

Use either:

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