Skip to content

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.

COUNTCOD
COUNTCX
COUNTMWK
COUNTNAME
COUNTNAMEUDFS
COUNTREG
COUNTTCH