Difference between revisions of "LASTREC()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
|||
(One intermediate revision by the same user not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return number of records in table | Function to return number of records in table | ||
− | |||
==Syntax== | ==Syntax== | ||
LASTREC([<workarea | alias>]) | LASTREC([<workarea | alias>]) | ||
− | |||
==See Also== | ==See Also== | ||
[[DBF()]], [[FCOUNT()]], [[HEADER()]], [[INDEXKEY()]], [[NDX()]], [[RECSIZE()]] | [[DBF()]], [[FCOUNT()]], [[HEADER()]], [[INDEXKEY()]], [[NDX()]], [[RECSIZE()]] | ||
− | |||
==Description== | ==Description== | ||
The LASTREC() 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 LASTREC() 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]] |
Latest revision as of 11:28, 10 February 2012
Contents
Purpose
Function to return number of records in table
Syntax
LASTREC([<workarea | alias>])
See Also
DBF(), FCOUNT(), HEADER(), INDEXKEY(), NDX(), RECSIZE()
Description
The LASTREC() 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 ? lastrec() 2500 ? fcount() 18 declare aAccounts[reccount(),fcount()] copy to array aAccounts for empty(paid_date)