Difference between revisions of "RECCOUNT()"
From Lianjapedia
(→Products) |
Yvonne.milne (Talk | contribs) |
||
(4 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return the number of records in table | Function to return the number of records in table | ||
− | |||
==Syntax== | ==Syntax== | ||
RECCOUNT([<workarea | alias>]) | RECCOUNT([<workarea | alias>]) | ||
− | |||
==See Also== | ==See Also== | ||
− | [[ | + | [[DBF()]], [[FCOUNT()]], [[INDEXKEY()]], [[NDX()]], [[RECSIZE()]], [[ROWCOUNT()]], [[TABLEROWCOUNT()]] |
− | + | ||
==Description== | ==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. | 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== | ==Example== | ||
Line 26: | Line 22: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
+ | [[Category:Cursor Functions]] |
Latest revision as of 08:09, 4 March 2013
Contents
Purpose
Function to return the number of records in table
Syntax
RECCOUNT([<workarea | alias>])
See Also
DBF(), FCOUNT(), INDEXKEY(), NDX(), RECSIZE(), ROWCOUNT(), TABLEROWCOUNT()
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)