Show AllSome of the content in this topic may not be applicable to some languages.
Determines the action Microsoft Query takes for queries based on different data source types. This command is available only on the system channel.
Syntax
SetQueryType(QueryType, CommandType)
Valid combinations of the QueryType and CommandType parameters are as follows:
| QueryType | CommandType | Description |
|---|---|---|
| ODBC | SQL | Edits the query in Microsoft Query. These values are assumed if the parameters are omitted. |
| OLEDB | Cube | Runs the OLAP Cube Wizard to change the cube definition. |
When you use SetQueryType(OLEDB, Cube), Microsoft Query ignores all LogonNow, EnableParameters, and SetQueryName commands, and UserControl2 arguments that are not valid within the context of editing a cube definition in the OLAP Cube Wizard.