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 Topics