AddNew (clsCollection)
.gif "ms133267.note(zh-cn,SQL.90).gif") 注意： |
|---|
| 下一版本的 Microsoft SQL Server 将删除该功能。请不要在新的开发工作中使用该功能，并尽快修改当前还在使用该功能的应用程序。 |
The AddNew method of a Decision Support Objects (DSO) collection creates and adds an object to a collection.
语法
Set vnt = object.AddNew(Name As String, [SubClassType As SubClassTypes])
参数
- vnt
A Variant variable that receives the instance of the new 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.
- Name
A string that specifies the name of the new object to add to the collection.
- SubClassType
(Optional) One of the values enumerated by the SubClassTypes enumeration. For more information, see SubClassTypes.
备注
The ClassType property of the new object is set automatically and depends on the parent of the collection to which the object is being added. For example, objects added to the MDStores collection of an object of ClassType clsDatabase automatically receive a ClassType value of clsCube.
The AddNew method maintains hierarchical relationships and ordering within the collection.
| 注意： |
|---|
| The AddNew method should be used when adding new objects to a collection. You should use the Add method only when adding existing objects: for example, when you are adding aggregations to a partition after you have designed them. For more information, see clsPartitionAnalyzer. |
示例
Use the following code to create a new cube and add it to the MDStores collection of cubes:
' Assume the existence of an object objDB
' of ClassType clsDatabase.
Dim objNewCube As MDStore
Set objNewCube = objDB.MDStores.AddNew("NewCube")