RequiredDataSet Properties |
The RequiredDataSet type exposes the following members.
Properties| Name | Description | |
|---|---|---|
 | Connection |
The name of a Data Connection to the SQL database in which the required data must be executed.
If "." is specified as connection, the connection to the enterprise server database is used.
|
| DataType |
Either "guid" or "integer" or "string" or "datatime".
The temp table "value" column will be created with that data type
|
| Sql |
A SQL statement which must return 1 column with the data type specified in the "dataType" attribute.
The paramters provided to the main query is also available for this query.
|
| TableName |
The name of the temporary table(without # prefix) that will be created.
The table always contains a single column named "value" and the data type will be the one specified in dataType
|
See Also