Compartilhar via


CustomProperties Collection

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 CustomProperties collection applies to all Decision Support Objects (DSO) objects and enables you to define unique properties for DSO objects. The CustomProperties collection contains Property objects that you define to store information you want to associate with a DSO object. For more information about defining custom properties, see Property Object.

Access

Read/write

Remarks

The CustomProperties collection implements its own methods and properties, which operate differently than those of other DSO collections.

Example

Use the following code example to add and retrieve custom property objects:

' Assume the existence of an object of ClassType clsDimension.
' Add a custom property.
  Dim dsoProp As DSO.Property
  Set dsoProp = dsoDim.CustomProperties.Add(55, "Age", vbInteger)

' Retrieve custom property values.
  Dim dsoProp2 As DSO.Property
  Set dsoProp2 = dsoDim.CustomProperties(1)
  Debug.Print dsoProp2.Name, dsoProp2.Value

See Also

Reference

Collections (DSO)
Methods, CustomProperties
Properties, CustomProperties

Help and Information

Getting SQL Server 2005 Assistance