[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
RECCOUNT()*
Determine the number of records in the current database (.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 affect 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). Note that RECCOUNT() is a
compatibility function. LASTREC() should be used in its place.
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.
See Also:
COUNT
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson