Tech Tip: Efficient Way to Count Records in Table
PRODUCT: 4D | VERSION: 18 | PLATFORM: Mac & Win
Published On: June 25, 2020
The command Records in table is useful when trying to find the number of records a table has. It may be tempting to find a count of records in a table using ALL RECORDS and Records in selection.
However, it is recommended find this information through a single call with Records in table instead.
Althogh these two methods provide the same results, the advantage of using Records in table is that it directly returns the amount of records in a given table. It does not perform a query and change the current selection like in the first example.
ALL RECORDS([Table]) $count:=Records in selection([Table]) |
However, it is recommended find this information through a single call with Records in table instead.
$count:=Records in table([Table]) |
Althogh these two methods provide the same results, the advantage of using Records in table is that it directly returns the amount of records in a given table. It does not perform a query and change the current selection like in the first example.