Skip to main content
Version: 20 R7 BETA

Records in table

Records in table {( aTable )} -> Function result

ParameterTypeDescription
aTableTableTable for which to return the number of records, or Default table, if omitted
Function resultLongintTotal number of records in the table

Description

Records in table returns the total number of records in aTable. Records in selection returns the number of records in the current selection only. If Records in table is used within a transaction, records created during the transaction will be taken into account.

Example

The following example displays an alert that shows the number of records in a table:

 ALERT("There are "+String(Records in table([People]))+" records in the table.")

See also

Records in selection