[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
+---------------------------------+
|              COUNT              |
+---------------------------------+
COUNT [<scope>]
        [FOR <expL1>]
        [WHILE <expL2>]
        [TO <memvar>]
        [NOOPTIMIZE]

-----------------------------------
Counts database records.
-----------------------------------

<scope>
        Counts only records that fall in range of records specified.

FOR <expL1>
        Counts only records that satisfy logical condition <expL1>.

WHILE <expL2>
        Counts records as long as logical expression <expL2> evaluates to true.

TO <memvar>
        Places results of count in memory variable.

NOOPTIMIZE
        Disables Rushmore.

+---------------------------------+
|         Program Example         |
+---------------------------------+
In this example, all customers from Perrysburg are counted.

USE customer
COUNT TO mcount FOR city = 'Perrysburg'
WAIT WINDOW 'Total customers from Perrysburg is '+ LTRIM(STR(mcount))

-----------------------------------

See Also:  CALCULATE, SET DELETED

-----------------------------------

See Also: CALCULATE SET DELETED
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson