COUNT Function (RecordRef)
Counts the number of records that are within the filters that are currently applied to the table referred to by the recordref.
Number := RecordRef.COUNT
Parameters
- RecordRef
-
Type: RecordRef
The recordref that refers to the table.
This function returns the number of records that meet the conditions of any filters associated with the records. If no filters are set, the function shows the total number of records in the table.
 Note |
|---|
|
The COUNT function does not lock the table before retrieving the number of records in the table. This means that the function reads both uncommitted and committed data, which could cause the number of records that is returned to be inaccurate. To ensure that the count is accurate, use the LOCKTABLE Function (RecordRef) before you use the COUNT function. |
This function works in the same way as the COUNT Function (Record).