NAME |
Required. The name you assign to the query. Query names must begin with a letter and may consist of letters, numbers, and the underscore character (spaces are not allowed). The query name is used later
in the page to reference the queries result set. |
DATASOURCE |
Required. The name of the ODBC data source from which this query should retrieve data. |
USERNAME |
Optional. If specified, USERNAME overrides the username value specified in the ODBC setup. |
PASSWORD |
Optional. If specified, PASSWORD overrides the password value specified in the ODBC setup. |
MAXROWS |
Optional. Specifies the maximum number of rows you want returned in the result set. |
TIMEOUT |
Optional. Lets you specify a maximum number of milliseconds for the query to execute before returning an error indicating that the query has timed-out. This attribute is not supported by most ODBC
drivers. TIMEOUT is supported by the SQL Server 6.x or above driver. |
DEBUG |
Optional. Used for debugging queries. Specifying this attribute causes the SQL statement actually submitted to the data source and the number of records returned from the query to be output. |