COUNT

Purpose

Count records in the active table that satisfy a specified condition

Syntax

COUNT

[IN <workarea>|<alias>]

[<scope>] TO <memvar>

[FOR <condition>]

[WHILE <condition>]

See Also

AVERAGE, LOCATE, SEEK, SET DELETED, SET FILTER, SUM, TOTAL , CALCULATE

Description

The COUNT command counts the number of records in the active table and stores the total to <memvar>. If no <scope> is specified, ALL records will be counted. If SET FILTER TO is in effect, then only those records that satisfy the filter <condition> are counted. If SET DELETED is ON, then records marked for deletion will not be included in the COUNT.

IN <workarea>|<alias>

If the workarea number, letter or alias name is specified, the COUNT is carried out in that workarea. Note, the IN clause must be the first clause. From v6.0.

FOR <condition>

If the for <condition> is used then only the records that satisfy the specified <condition> are counted.

WHILE <condition>

The WHILE clause can be used in conjunction with the SEEK or LOCATE commands to restrict the range of records counted. When the WHILE option is used the <scope> defaults to REST.

Example

use patrons
count to nResult for event = "CHOPIN" and date = date()