Count (open)

Aggregate function which returns the number of records

Syntax

// Core function, no LOADLIB necessary

INTEGER FUNCTION Count(VARIANT data)

Parameters

VARIANT data

Array of records

Return value

INTEGER

Returns the number of records passed.

Description

Count is an aggregate function which can be used in SELECT statements, and which counts the number of records in a group. At the moment, only the form count(*) is allowed. Count can only be used within a SELECT statement, and specifically only in the HAVING, ORDER BY clauses and in the list of selected cells.