Difference between revisions of "RECCOUNT()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
|||
Line 8: | Line 8: | ||
==See Also== | ==See Also== | ||
− | [[RECSIZE()]], [[DBF()]], [[NDX()]], [[ | + | [[RECSIZE()]], [[DBF()]], [[NDX()]], [[FCOUNT()]], [[INDEXKEY()]], [[ROWCOUNT()]] |
Line 26: | Line 26: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] |
Revision as of 07:23, 7 February 2012
Contents
Purpose
Function to return the number of records in table
Syntax
RECCOUNT([<workarea | alias>])
See Also
RECSIZE(), DBF(), NDX(), FCOUNT(), INDEXKEY(), ROWCOUNT()
Description
The RECCOUNT() function returns a number representing the total number of records in the currently selected table. This number includes records that have been marked for deletion. If the optional <workarea | alias> is specified, then the function will operate in the required location.
Example
use accounts ? reccount() 2500 ? fcount() 18 declare aAccounts[reccount(),fcount()] copy to array aAccounts for empty(paid_date)