Click above to get retro games delivered to your door ever month!

 RECCOUNT()*
 Determine the number of records in the current (.dbf) file
------------------------------------------------------------------------------
 Syntax

     RECCOUNT()* | LASTREC() --> nRecords

 Returns

     RECCOUNT() returns the number of physical records in the current
     database file as an integer numeric value.  Filtering commands such as
     SET FILTER or SET DELETED have no effect on the return value.
     RECCOUNT() returns zero if there is no database file open in the current
     work area.

 Description

     RECCOUNT() is a database function that is a synonym for LASTREC().  By
     default, RECCOUNT() operates on the currently selected work area.  It
     will operate on an unselected work area if you specify it as part of an
     aliased expression (see example below).

 Examples

     .  This example illustrates the relationship between COUNT and
        RECCOUNT():

        USE Sales NEW
        ? RECCOUNT()                      // Result: 84
        //
        SET FILTER TO Salesman = "1001"
        COUNT TO nRecords
        ? nRecords                        // Result: 14
        ? RECCOUNT()                      // Result: 84

     .  This example uses an aliased expression to access the number
        of records in an unselected work area:

        USE Sales NEW
        USE Customer NEW
        ? RECCOUNT(), Sales->(RECCOUNT())

 Files:  Library is CLIPPER.LIB.