Ryan -

old and new only apply to triggers - or is that what you meant ?

bill

Ryan Nilsson-Harding wrote:

>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
>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>