Subject OR in stored procs
Author Ryan Nilsson-Harding
Hi there,

I'm trying to do something like this in a stored procedure:

IF
((old.LABRATE <> new.LABRATE) OR
(old.EXRATE <> new.EXRATE)) THEN
INSERT INTO ....
....

But it is balking on the 'OR'.

Am I missing something, or can you NOT use 'OR' in a stored proc?

Please forgive me if this is a stupid question, but I've just had a
look through the IB6 docs, and nothing is mentioned about AND/OR,
nor is there any example which uses either of these.

Rgds,
-Ryan