Item (clsCollection)

Hinweis
Diese Funktion wird in der nächsten Version von Microsoft SQL Server entfernt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie so bald wie möglich das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

The Item method of a Decision Support Objects (DSO) collection returns an instance of an item in the collection. This method does not apply to CustomProperties collections.

Syntax

Set vnt = object.Item(vntIndexKey)

Parameter

• vnt
  A Variant variable that receives the instance of the member. Instead of a variant, you can use a variable that has been declared to match the object being retrieved from the collection. For example, a variable declared as type MDStore, with its ClassType property value set to clsCube, can be used to retrieve an object from an MDStores collection of clsCube objects.

• object
  An instance of a DSO collection object.

• vntIndexKey
  Can be either the index (integer) or key (string) to the collection.

  Hinweis
  All collections in the DSO object model are one-based. That is, the first item in the collection has an index of 1 and the last item has an index of Count.

Beispiel

Use the following code to return the partition named EastCoast from the MDStores collection of partitions for a cube:

' Assume the existence of an object cubCube
' of ClassType clsCube.
Dim Temp_Partition As MDStore 
' Retrieve using the key
Set Temp_Partition = cubCube.MDStores.Item("EastCoast") 
' OR Retrieve using the Index
Set Temp_Partition = cubCube.MDStores.Item(2) 
 

Siehe auch

Verweis

Collections