Parameters Object

The Parameters object represents a collection of the Parameter objects and provides methods for controlling and accessing the stored objects.

Methods

Count Returns the number of objects, stored in the collection.
Append Adds a new object to the collection.
GetByName Gets an object from the collection by its name.
GetByNumber Gets an object from the collection by its number.
DeleteByName Removes an object from the collection by its name.
DeleteByNum Removes an object from the collection by its number.
Refresh Refreshes the object collection.

Remarks

The Parameters object belongs to the QueryDef object and can be retrieved by calling the Parameters method.

For existing stored procedures the call of the Append, DeleteByName and DeleteByNum methods does not cause an actual change of the number of parameters.

 

See Also

Parameter Object, QueryDef Object, Parameters Method