query

Loads the window list (WL) using the window SELECT statement.

Available in:

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

Syntax

void query(data[,add-where[,add-end]])
int        data
string     add-where,add-end

Description

Fetches a maximum of data tuples. To fetch more tuples, use the list_more() function.
data specifies the maximum number of tuples to fetch. If data = -1, the function performs a describe on the window SELECT statement and puts the results in the window list.

If the window has the default triggers attribute, then the appropriate row identifier column becomes the first column of the window SELECT list. For example, in Oracle, A.row-id becomes the first column of the window list.

add-where (optional) is appended to the #where_begin #where_end sequence; WHERE and AND are inserted where needed. If the query does not have the #where_begin/#where_end tags, this parameter is ignored.

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

Example

Retrieves up to 1,000 tuples as specified in the SELECT statement:
query(1000,"salary BETWEEN 10000 AND 20000","ORDER BY salary DESC");
See the default window trigger in DesignVision Users Guide.