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