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

RECCOUNT()/LASTREC()


Syntax:     RECCOUNT()/LASTREC()

Purpose:    To determine the number of physical records in the current
            database file.

Returns:    An integer numeric value.

            RECCOUNT() returns the number of physical records in the
            current database file.  This means that filtering commands
            such as SET FILTER or SET DELETED have no affect on the
            return value.

            RECCOUNT() returns zero if there is no database file in USE
            in the current work area.

Library:    CLIPPER.LIB


----------------------------------- Examples -------------------------------

   USE Sales
   ? RECCOUNT()                     && Result: 84
   *
   SET FILTER TO Salesman = "1001"
   COUNT TO num_recs
   ? num_recs                       && Result: 14
   ? RECCOUNT()                     && Result: 84