Skip to main content

NONEMPTY

NONEMPTY(recordsetlist)

recordsetlistA comma-delimited list of record sets.
Return:NONEMPTY returns a record set.

The NONEMPTY function returns the first record set from the recordsetlist that contains any records. This is similar to using the EXISTS function in an IF expression to return one of two possible record sets.

Example:

  ds := NONEMPTY(SomeData(SomeFilter),
                 SomeData(SomeOtherFilter),
                 SomeOtherData(YetAnotherFilter));

See Also: EXISTS