| recordsetlist | A 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