LASTREC()

From Lianjapedia
Revision as of 11:28, 10 February 2012 by Yvonne.milne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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)