O$: Null Fields
Kelly Burgess
kellyb at montana.com
Wed Apr 22 00:41:01 EDT 2009
Hi Christine,
>If (pOldRow.FF_HIRED<>pNewRow.FF_HIRED) |
>(pOldRow.FF_PREVIOUS_MONTHS<>pNewRow.FF_PREVIOUS_MONTHS)
> ...
>It still fails though because of the nulls.
One thing you can do for simple tests like the above is to structure
them to account for the fact that if anything in your expression is
NULL, the if() test will fail. So when you write that test the other
way round:
If (pOldRow.FF_HIRED=pNewRow.FF_HIRED) &
(pOldRow.FF_PREVIOUS_MONTHS=pNewRow.FF_PREVIOUS_MONTHS)
and do your positive stuff inside that if(), you can let the NULLs
fall through to the Else part, along with any non-null non-matches.
Kelly
More information about the omnisdev-en
mailing list