Class Parameters (ADODB VBA)

Contains all the Parameter objects of a Command object. To use a Parameters class variable it first needs to be instantiated, for example

Append

Appends an object to a collection. If the collection is Fields, a new Field object may be created before it is appended to the collection.

Append (Object)

Object: An object variable that represents the object to be appended.

Count

Indicates the number of objects in a collection.

Use the Count property to determine how many objects are in a given collection. Because numbering for members of a collection begins with zero, you should always code loops starting with the zero member and ending with the value of the Count property minus 1. If you are using Microsoft Visual Basic and want to loop through the members of a collection without checking the Count property, use the For Each...Next command. If the Count property is zero, there are no objects in the collection.

Delete

Deletes an object from the Parameters collection.

Using the Delete method on a collection lets you remove one of the objects in the collection. This method is available only on the Parameters collection of a Command object. You must use the Parameter object's Name property or its collection index when calling the Delete method-an object variable is not a valid argument.

Delete (Index)

Item

Indicates a specific member of a collection, by name or ordinal number.

Use the Item property to return a specific object in a collection. If Item cannot find an object in the collection corresponding to the Index argument, an error occurs. Also, some collections don't support named objects; for these collections, you must use ordinal number references. The Item property is the default property for all collections; therefore, the following syntax forms are interchangeable:

Item (Index)

Index: A Variant expression that evaluates either to the name or to the ordinal number of an object in a collection.

Refresh

Updates the objects in a collection to reflect objects available from, and specific to, the provider.

The Refresh method accomplishes different tasks depending on the collection from which you call it.