Skip to main content
Version: 20 R10

Records in table

Records in table* {( aTable )} : Integer

ParameterTypeDescription
aTableTableTable for which to return the number of records, or Default table, if omitted
Function resultIntegerTotal 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

Properties

Command number83
Thread safe