O$: Null Fields

Christine Penner christine at ingenioussoftware.com
Tue Apr 21 11:23:57 EDT 2009


Hi Everyone,

We are in the process of converting our software to SQL. In the old 
DML code we never had to deal with nulls much. Now I need some advice 
how to deal with them in some specific problems that have come up. We 
decided in most cases we don't want the overhead of always clearing 
nulls after finding data.

When we have one field we are looking at there is no problem. When we 
have more than one it can cause problems. Here is an example. Any 
suggestions would be appreciated.

If 
(pOldRow.FF_HIRED<>pNewRow.FF_HIRED)|(pOldRow.FF_PREVIOUS_MONTHS<>pNewRow.FF_PREVIOUS_MONTHS) 

In this case we compare old and new values to see if anything has 
changed. Typically in this situation everything will be null except 
pNewRow.FF_HIRED. It still fails though because of the nulls. We do 
this type of thing all over the program. It would be good to not have 
to write a pile of code each time checking for nulls.

Christine




More information about the omnisdev-en mailing list