Knowledge Base

When working in the calc tab, it is sometimes necessary to determine whether a field was null or not.

In the case of a Float, null is sometimes interpretted as 0, which makes this difficult.  The trick is to have a DBText tied to the field you want to test.

In the calc tab, you can use code similar to the following, where DBText12 is tied to MYPIPELINE.Float_field.


if (MYPIPELINE['Float_field'] = nil) and (DBText12.FIeldValue <> nil) then

  showmessage('NULL')

else

  showmessage('NOT NULL: '+floattostr(DBText12.FIeldValue));