)

---

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.