Item (clsCollection)

メモ :
この機能は、Microsoft SQL Server の次のバージョンで削除されます。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションはできるだけ早く修正してください。

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.

構文

Set vnt = object.Item(vntIndexKey)

パラメータ

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

  メモ :
  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.

使用例

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) 
 

参照

その他の技術情報

Collections

ヘルプおよび情報

SQL Server 2005 の参考資料の入手