Property Object (DSO)

Примечание.
В следующей версии Microsoft SQL Server эта возможность будет удалена. Не используйте ее при работе над новыми приложениями и как можно быстрее измените приложения, в которых она в настоящее время используется.

Use the Property object to save user-defined items to a CustomPropertiescollection. You can define Property objects and add them to the CustomProperties collection of any Decision Support Objects (DSO) object to store information you want to associate with the DSO object. You provide a name, value, and data type for each Property object.

Замечания

The Property object has properties, but no collections or methods. The Property object is unlike other DSO objects in that it does not implement any of the interfaces, methods, properties, or collections of other DSO objects.

Examples

Creating a New Custom Property

Use the following code to create a new custom property:

'Assume an object of ClassType clsDimension exists.
'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

См. также

Справочник

CustomProperties Collection
Properties, Property Object

Справка и поддержка

Получение помощи по SQL Server 2005