Difference between revisions of "RECCOUNT()"

Revision as of 16:01, 28 October 2009

Purpose

Function to return the number of records in table

Syntax

RECCOUNT([<workarea | alias>])

See Also

RECSIZE(), DBF(), NDX(), HEADER(), FCOUNT(), INDEXKEY()

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)

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer