Difference between revisions of "ROWCOUNT()"
From Lianjapedia
(Created page with '==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 Al…') |
|||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return the number of records in table, excluding deleted records and those not in the active filter | Function to return the number of records in table, excluding deleted records and those not in the active filter | ||
− | |||
==Syntax== | ==Syntax== | ||
ROWCOUNT([<workarea | alias>]) | ROWCOUNT([<workarea | alias>]) | ||
− | |||
==See Also== | ==See Also== | ||
[[DBF()]], [[FCOUNT()]], [[FILTER()]], [[INDEXKEY()]], [[NDX()]], [[RECCOUNT()]], [[RECSIZE()]], [[SET FILTER]] | [[DBF()]], [[FCOUNT()]], [[FILTER()]], [[INDEXKEY()]], [[NDX()]], [[RECCOUNT()]], [[RECSIZE()]], [[SET FILTER]] | ||
− | |||
==Description== | ==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. | 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== | ==Example== |
Revision as of 07:25, 7 February 2012
Contents
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(), 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