SetQueryType Command (DDE)

Microsoft Query

Show All Show All

SetQueryType Command (DDE)

Some 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.