Difference between revisions of "RECCOUNT()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) (→RECCOUNT()) |
||
Line 1: | Line 1: | ||
− | + | ==Purpose== | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | ==Purpose== | + | |
Function to return the number of records in table | Function to return the number of records in table | ||
Revision as of 15:59, 28 October 2009
==Purpose==
Function to return the number of records in table
Contents
Syntax
RECCOUNT([<workarea | alias>])
See Also
RECSIZE(), DBF(), NDX(), HEADER(), FCOUNT(), INDEXKEY()
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 Database Server, Recital Mirage Server, Recital Terminal Developer