ADO: ActiveX Data Objects

Name

Parameters.Append Method — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

                     parameters.Append Object
                  

The Append method appends a new Parameter object to the current Parameters collection class.

Arguments

Object

The only parameter of the Append method is a Parameter object. The Type property of the Parameter object must be set before the Append method is actually called. In addition, if the datatype of your Parameter is of variable length, you must also set the Size property of the Parameter object to a value greater than zero.

Description

The Append method of the Parameters collection informs ADO of the type of parameters that are included in stored procedures or parameterized queries. You would do this for a couple of reasons: one is that it decreases the time that a stored procedure or parameterized query takes to perform its duty by minimizing the calls to the data provider for this information. Another reason for declaring the parameters in advance -- by adding them to the Parameters collection -- is that not all data providers actually make this information known to ADO. For this reason, unless you populate the Parameters collection yourself, you stand a strong chance of not being able to use these stored procedures or queries at all.

It is my advice (as well as Microsoft’s) to always declare the parameters of a stored procedure or parameterized query in advance whenever possible, because you may not always be able to rely on the information being available to ADO (and it can’t hurt ...