Append Method Remarks

You are here: ADO Component Reference > ADO Collections > ADO Collections Methods > ADO Collections Append Method > Append Method Remarks

Append Method Remarks

Use the Append method on a collection to add an object to that collection. This method is available only on the Parameters collection of a ADO Command Object. You must set the ADO Parameter Object Type Property of an ADO Parameter Object before appending it to the Parameters collection. If you select a variable-length data type, you must also set the ADO Parameter Object Size Property to a value greater than zero.

By describing the parameter yourself, you can minimize calls to the provider and consequently improve performance when using stored procedures or parameterized queries. However, you must know the properties of the parameters associated with the stored procedure or parameterized query you wish to call. Use the CreateParameter method to create Parameter objects with the appropriate property settings and use the Append method to add them to the Parameters collection. This lets you set and return parameter values without having to call the provider for the parameter information. If you are writing to a provider that does not supply parameter information, you must manually populate the Parameters collection using this method to be able to use parameters at all.