• Article

Find (clsCollection)

Note

  This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

The Find method of a Decision Support Objects (DSO) collection locates an item in a collection. This method does not apply to CustomProperties collections.

Syntax

bPresent = object.Find(vKey)

Parameters

  • bPresent
    A Boolean variable that receives the returned value: True if the item was found, False otherwise.

  • object
    An instance of a DSO collection object.

  • vKey
    The key or index of the item to be found.

Example

Use the following code to check for the existence of a partition named EastCoast in the MDStores collection of partitions for a cube:

' Assume the existence of an object cubCube
' of ClassType clsCube.
Dim bPresent As Boolean 
bPresent = cubCube.MDStores.Find("EastCoast")

See Also

Reference

Collections