Subject | OR in stored procs |
---|---|
Author | Ryan Nilsson-Harding |
Post date | 2002-10-25T05:54:25Z |
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
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