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