Difference between revisions of "TABLEROWCOUNT()"
From Lianjapedia
Yvonne.milne (Talk | contribs) (Created page with "==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(<t...") |
Yvonne.milne (Talk | contribs) |
||
Line 20: | Line 20: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
+ | [[Category:Cursor Functions]] |
Latest revision as of 08:08, 4 March 2013
Contents
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