Difference between revisions of "RECCOUNT()"
From Recital Documentation Wiki
Helengeorge (Talk | contribs) (→RECCOUNT()) |
Yvonnemilne (Talk | contribs) |
||
(2 intermediate revisions by one user not shown) | |||
Line 1: | Line 1: | ||
− | + | ==Purpose== | |
Function to return the number of records in table | Function to return the number of records in table | ||
Line 8: | Line 8: | ||
==See Also== | ==See Also== | ||
− | [[ | + | [[DBF()]], [[FCOUNT()]], [[HEADER()]], [[INDEXKEY()]], [[NDX()]], [[RECSIZE()]], [[ROWCOUNT()]] |
Line 28: | Line 28: | ||
==Products== | ==Products== | ||
− | Recital | + | Recital, Recital Server |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] |
Latest revision as of 11:16, 7 February 2012
Purpose
Function to return the number of records in table
Syntax
RECCOUNT([<workarea | alias>])
See Also
DBF(), FCOUNT(), HEADER(), INDEXKEY(), NDX(), RECSIZE(), 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)
Products
Recital, Recital Server