O$: Null Fields
Christine Penner
christine at ingenioussoftware.com
Wed Apr 22 11:17:33 EDT 2009
Kelly,
I like that. That's the kind of thing I was looking for.
I do that with simpler cases but I couldn't think of that in this case.
Thanks
Christine
At 09:41 PM 21/04/2009, you wrote:
>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
>_____________________________________________________________
>Manage your list subscriptions at http://lists.omnis-dev.com
More information about the omnisdev-en
mailing list