GETSQLCOUNT

Returns the number of records that meet the specified condition.

Reporting Area(s)

General

Required Parameters

1. Sequel Statement (i.e. 'select from table where field equals a value')

Optional Parameters

None

Example(s)

GETSQLCOUNT('select * from NAMES where nmfirm="ACEware Systems, Inc." ') returns the number of Name records with ACEware Systems, Inc. in the firm field.

Related Functions

COUNTCOD
COUNTCX
COUNTMWK
COUNTNAME
COUNTNAMEUDFS
COUNTREG
COUNTTCH