OrdinalPosition

The OrdinalPosition property of the Command interface contains the ordinal position of a command in the Commands collection in the parent MDStore object. Ordinal position determines the order in which commands are executed. This order is important when one command depends on another command (for example, a CREATE SET command that uses a member defined in a CREATE MEMBER command). In this case the CREATE MEMBER command should have a lower OrdinalPosition property value than the CREATE SET command.

Applies To
clsCubeCommand clsDatabaseCommand

Data Type

Integer

Access

Read-only

Example

Use the following code to return a the ordinal position of a command object:

'Assume an object (dsoDB) of ClassType clsDatabase exists

Dim strStatement As String

Dim iCounter As Integer

Dim dsoCmd As DSO.Command

'To check that the first command creates a member

Set dsoCmd = dsoDB.Commands(1)

For iCounter = 1 To dsoDB.Commands.Count

    Set dsoCmd = dsoDB.Commands(iCounter)

    Select Case dsoCmd.OrdinalPosition

        Case 1

         strStatement = dsoCmd.Statement

         If Left$(strStatement, 13) <> "CREATE MEMBER" Then

          'Error in command

        End If

       Case Else

          'Other validation

    End Select

Next iCounter

See Also
About Decision Support Objects Using Decision Support Objects
Properties Cross-Reference  

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.