Records in table

4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next

version 3


Records in table {(aTable)} Number

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


4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next