count

Counts the number of fetches or parameters.

Available in:

Apps (win) Apps (char) Reportwriter RPC Standalone PL
X X X X X

Syntax

int count(field | parm)
ident     field
keyword   parm

Description

field(only used in Reportwriter) specifies that count returns the number of fetches that returned a non-NULL value for that field in the invocation of the current block.

parm specifies that count returns the number of parameters used in calling the current trigger.

Notes

If field is not a database field, the result is undefined. count(parm) is always valid.

Example

Counts the number of non-NULL salaries.
cnt_sal = count(SAL);
Count the number of parameters passed to the trigger.
parm_cnt = count(parm);