query_count

Gets the number of qualifying tuples in window SELECT statement.

Available in:

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

Syntax

numeric query_count([add-where[,add-end]])
string           add-where,add-end

Description

Returns the number of qualifying tuples in window SELECT.
add-where (optional) is appended to the # where_begin # where_end sequence; WHERE and AND are inserted where needed.

add-end (optional) is appended to the SELECT statement; no blank is inserted before add-end.

Example

Prompts user for confirmation before fetching data:
{
numeric cnt;
char    answer[1];
cnt    = query_count();
answer = prompt("Query returns " ^^ cnt ^^ " tuples.  OK(Y/N)?");
if (answer in ("Y","y")) query(cnt);
}