Skip to content

COUNTIT

Returns the number of records that meet your specified condition. Used to get a total count from an otherwise unrelated data table.

Reporting Area(s)

General

Required Parameters

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

Optional Parameters

None

Example(s)

COUNTIT('select * from NAMES where nmfirm="ACEware Systems, Inc." into cursor Temp') returns the number of Name records with the ACEware Systems, Inc.

Notes

You must use a Temp cursor with this function. Do not put it into cursors 1-5.

COUNTCOD
COUNTCX
COUNTMWK
COUNTNAME
COUNTNAMEUDFS
COUNTREG
COUNTTCH
GETSQLCOUNT
JUSTDOIT