ADO » Parameters » Append

Syntax:

Parameters.Append Object

Object

The Object parameter is the Parameter object to be appended.

The Append method is used to add (append) a Parameter object to the Parameters Collection.

Before appending, make sure to set the Type property for the Parameter object. You will also need to set the Size property for variable-length data types. In the example, note the use of the CreateParameter method which is used to create a Parameter object and to set the Name, Type and Direction. (It can also be used to set the Size and Value.)