4D v16.3

Records in table

Home

4D Language Reference
- Records
- - About Record Numbers
  - Using the Record Stack
  - CREATE RECORD
  - DELETE RECORD
  - DISPLAY RECORD
  - DUPLICATE RECORD
  - GOTO RECORD
  - Is new record
  - Is record loaded
  - Modified record
  - POP RECORD
  - PUSH RECORD
  - Record number
  - Records in table
  - SAVE RECORD
  - Sequence number

Home

4D v16.3

4D Language Reference

Records

Records in table


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

Parameter	Type	Description
aTable	Table	Table for which to return the number of records, or Default table, if omitted
Function result	Longint	Total 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.")