Add (CustomProperties Collection)

附註：
下一版的 Microsoft SQL Server 將不再提供此功能。請勿在新的開發工作中使用此功能，並且儘速修改使用此功能的應用程式。

The Add method of a CustomProperties collection creates a new Property object, adds it to the collection, and returns a reference to the object. This method applies only to CustomProperties collections.

語法

Set vRet = object.Add(ByVal Value, [ByVal Name As String], [ByVal DataType As VBA.VbVarType)

備註

• vRet
  A Variant variable that receives the instance of the new Property object. Instead of a variant, you can use a variable that has been declared as type DSO.Property to match the object being retrieved from the collection.

• object
  An instance of a CustomProperties collection.

• Value
  A Variant that contains the value of the Property object.

• Name
  (Optional) A string that specifies the name of the Property object.

• DataType
  (Optional) The data type of the property. A Microsoft® Visual Basic® data type defined in the VBA.VbVarType enumeration.

請參閱

參考

CustomProperties Collection
Property Object (DSO)

說明及資訊

取得 SQL Server 2005 協助