void query(data[,add-where[,add-end]]) int data string add-where,add-end
|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.|
query(1000,"salary BETWEEN 10000 AND 20000","ORDER BY salary DESC");See the default window trigger in DesignVision Users Guide.