Dear Community Members,
i want to check if my complete table is empty.
IsEmpty functions shows field when I type the function.
How can I check if my complete table is empty or not?
If by "empty" you mean no records, you can use:
Get ( TotalRecordCount ) < 1
On the other hand, if you mean "all fields in this record (or all records)", then it gets more complicated.
A table is empty (has no records) if
not Get ( TotalRecordCount )
or, if you wish,
Get ( TotalRecordCount ) = 0
Note that there is no parameter/argument for a table; you must be in the context of the table to be checked while using that expression.
Hello Mike and Erolst,
Thank you very much for prompt answer to my query.
It helped me a lot.
Retrieving data ...