The RECORDSET object is used to define the set of results
a query will return. The recordset is used by Data Output objects to access
and display data. The RECORDSET object is used to define the set of results
a query will return. The recordset is used by Data Output objects to access
and display data.
|
Attribute |
Description |
Required? |
|
NAME
|
Name for the query result recordset. |
Required
|
|
SQL WIZARD
|
Use an SQL Editor to add tables and data fields, and filter the query result set. See Using the SQL Wizard. |
|
|
ORDER BY
|
Orders query results by the first specified data field. |
Optional |
|
SORT
|
Sorts query column data. Default is Ascending. |
Optional |
|
SQL CUSTOM
|
Add SQL statements to define tables, data fields and filter the query result set.
|
Optional |
|
MAXROWS
|
The maximum number of rows returned in the recordset. If no number is specified, all rows will be returned. Default is -1. |
Optional |
Next 