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
- 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.
Related Functions
COUNTCOD
COUNTCX
COUNTMWK
COUNTNAME
COUNTNAMEUDFS
COUNTREG
COUNTTCH
GETSQLCOUNT
JUSTDOIT