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


History

VersionStatusNotes
10.0NewNew in this version.