[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 COUNT
 Tally records to a variable
------------------------------------------------------------------------------
 Syntax

     COUNT TO <idVar>
        [<scope>] [WHILE <lCondition>] [FOR <lCondition>]

 Arguments

     TO <idVar> identifies the variable that holds the COUNT result.  A
     variable that either does not exist or is invisible is created as a
     private variable whose scope is the current procedure.

     <scope> is the portion of the current database file to COUNT.  The
     default is ALL records.

     WHILE <lCondition> specifies the set of records meeting the
     condition from the current record until the condition fails.

     FOR <lCondition> specifies the conditional set of records to COUNT
     within the given scope.

 Description

     COUNT tallies the number of records from the current work area that
     match the specified record scope and conditions.  The result is then
     placed in the specified variable.  <idVar> can be a variable of any
     storage class including a field.

 Examples

     .  This example demonstrates a COUNT of Branches in Sales.dbf:

        USE Sales NEW
        COUNT TO nBranchCnt FOR Branch = 100
        ? nBranchCnt                           // Result: 4

     .  This example tallies the number of records in Sales.dbf whose
        Branch has the value of 100 and assigns the result to the Count field
        in Branch.dbf for branch 100:

        USE Branch INDEX Branch NEW
        SEEK 100
        USE Sales INDEX SalesBranch NEW
        SEEK 100
        COUNT TO Branch->Count WHILE Branch = 100

 Files   Library is CLIPPER.LIB.


See Also: AVERAGE DBEVAL() SUM TOTAL
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson