emptycell(
emptycell(
FIELD
)

The emptycell( function returns true if the specified field is empty in the current record.

Parameters

This function has one parameter:

field – name of the field to test.

Description

This function returns true if the specified field is empty in the current record. It doesn’t matter what type of data is in the field – text, numbers, dates or binary data.

    emptycell("Quantity") ☞ -1

For example you could select all records where the Date field is empty.

    select emptycell("Date")=true()

See Also

- emptyline( -- returns true if the entire current record (all fields) is blank, otherwise it is false.

History

Version | Status | Notes
10.0 | New | New in this version.