CommandType (Command Interface)
Nota
Questa caratteristica verrà rimossa a partire dalla prossima versione di Microsoft SQL Server. Non utilizzare questa caratteristica in un nuovo progetto di sviluppo e modificare non appena possibile le applicazioni in cui è attualmente implementata.
The CommandType property of the Command interface contains an enumeration constant that identifies the command option.
Applies To:clsCubeCommand, clsDatabaseCommand, clsRoleCommand
Access
Read/write
Osservazioni
The value of CommandType determines how the Analysis server interprets the command object. The following table lists the possible values.
Command type |
Description |
|---|---|
cmdCreateAction |
The command contains a CREATE ACTION statement. For more information, see CREATE ACTION Statement. |
cmdCreateMember |
The command defines one or more calculated members. |
cmdCreateSet |
The command defines one or more sets of existing members. |
cmdUseLibrary |
The command specifies a third-party DLL that contains functions to be registered for use in Multidimensional Expressions (MDX). |
cmdUnknown |
The command defines statements that are not included in any of the other command types, such as DROP MEMBER statements or new statements that may be added to future versions. |
cmdCreateCellCalculation |
The command defines a calculated cells definition. |
.gif "Nota importante") Importante |
|---|
To ensure compatibility with Analysis Manager, you should create only one action, calculated member, named set, or calculated cells definition per command. |
Examples
A. Specifying the Command Type
Use the following code to specify a command type for an existing command object:
CommandObject.CommandType = cmdCreateMember
B. Determining the Command Type
Use the following code to determine the type of command in use:
Dim CommandType As DSO.CommandTypes
CommandType = CommandObject.CommandType
Select Case CommandType
Case cmdCreateAction
' Insert code to create an action.
Case cmdCreateMember
' Insert code to define a calculated member.
Case cmsCreateSet
' Insert code to define a named set of existing members.
Case cmdUseLibrary
' Insert code to use a third-party library.
Case cmdCreateCellCalculation
' Insert code to create a calculated cells definition.
Case cmdUnknown
' Insert code to define other statements.
End Select