Difference between revisions of "ROWCOUNT()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 8: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[ | + | [[DBF()]], [[FCOUNT()]], [[FILTER()]], [[HEADER()]], [[INDEXKEY()]], [[NDX()]], [[RECCOUNT()]], [[RECSIZE()]], [[SET FILTER]] |
Latest revision as of 11:17, 7 February 2012
Purpose
Function to return the number of records in table, excluding deleted records and those not in the active filter
Syntax
ROWCOUNT([<workarea | alias>])
See Also
DBF(), FCOUNT(), FILTER(), HEADER(), INDEXKEY(), NDX(), RECCOUNT(), RECSIZE(), SET FILTER
Description
The ROWCOUNT() function returns a number representing the total number of records in the currently selected table. This number excludes records that have been marked for deletion or do not match the active filter. If the optional <workarea | alias> is specified, then the function will operate in the required location.
Example
use accounts ? reccount() 2500 delete first 10 ? rowcount() 2490
Products
Recital, Recital Server
