Subject | Variable references in IF() Include full colon or not? |
---|---|
Author | red_october_canada |
Post date | 2007-07-12T15:39:51Z |
There seems to be a difference in an IF() function if the condition
includes a variable, and if the variable is prefixed by a full colon (:)
Example: IF(V_MYVAR IS NULL) THEN
versus IF(:V_MYVAR IS NULL) THEN
FB 2.01 will not complain about either syntax.
Which is correct? Include the semi-colon or not?
And, in other cases, like subsequent UPDATEs or SELECTs (after the
select that loaded the variable in the first place) should I include
the full colon or not?
Thanks in advance for any help.
includes a variable, and if the variable is prefixed by a full colon (:)
Example: IF(V_MYVAR IS NULL) THEN
versus IF(:V_MYVAR IS NULL) THEN
FB 2.01 will not complain about either syntax.
Which is correct? Include the semi-colon or not?
And, in other cases, like subsequent UPDATEs or SELECTs (after the
select that loaded the variable in the first place) should I include
the full colon or not?
Thanks in advance for any help.