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)