7 57 2 IF_NULL Comments Warnings

LANSA Technical

7.57.2 IF_NULL Comments / Warnings

Fields that are SQL Null will fail the IF_NULL check.

If you only need to check for SQL Null, use code like the following:

If '#FIELD.IsSqlNull'

Endif
 

If you want a condition to return True if the field is SQL Null or Null, use code like the following:

If '#FIELD.IsSqlNull *OR #FIELD.IsNull'

Endif
 

Alternatively, you can compare against the null value for the field. The following If example returns True if #Field is *SQLNULL or *NULL (assuming #Field is numeric) .

If '#FIELD *EQ *ZERO'

Endif