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

COUNT


Syntax:     COUNT [<scope>] [FOR <condition>] [WHILE <condition>] TO
            <memvar>

Purpose:    To tally records from the current work area to a memory
            variable within the specified scope and specified
            conditions.

Argument:   <memvar> is a memory variable assigned the value of the
            COUNT result.  If the variable does not exist or is not
            numeric type, COUNT creates it as numeric.

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

            Condition: The FOR clause specifies the conditional set
            of records to COUNT within the given scope.  The WHILE
            clause specifies the set of records meeting the condition
            from the current record until the condition fails.

Library:    CLIPPER.LIB


----------------------------------- Example --------------------------------

   USE Sales
   ? LASTREC()                               && Result: 84

   COUNT FOR Branch = "100" TO branch_cnt
   ? branch_cnt                              && Result: 4