TABLEROWCOUNT()

Purpose

Function to return the number of records in table, excluding deleted records and, if the table is open, those not in the active filter

Syntax

TABLEROWCOUNT(<tablename | alias>)

See Also

DBF(), FCOUNT(), FILTER(), INDEXKEY(), NDX(), RECCOUNT(), RECSIZE(), ROWCOUNT(), SET FILTER

Description

The TABLEROWCOUNT() function returns a number representing the total number of records in the specified table. Unlike RECCOUNT() or ROWCOUNT(), the TABLEROWCOUNT() function can operate on tables that are not currently open. The number of records returned excludes records that have been marked for deletion. On open tables, which can be accessed by their alias, the number also excludes records that do not match the active filter.

Example

open database southwind
? tablerowcount("orders")
       823