O$: Null Fields

Christine Penner christine at ingenioussoftware.com
Wed Apr 22 11:17:33 EDT 2009


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.


At 09:41 PM 21/04/2009, you wrote:
>Hi Christine,
>>If (pOldRow.FF_HIRED<>pNewRow.FF_HIRED) | 
>>  ...
>>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) & 
>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.
>Manage your list subscriptions at http://lists.omnis-dev.com

More information about the omnisdev-en mailing list