AddNew (clsCollection)

[!附註]

  下一版的 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") 
 

請參閱

參考