[<<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