ADO Parameters Collection >> Delete Method

The Delete method deletes an object from the Parameters collection.

You must call the Update method of the Fields Collection to make this deletion. This method has one parameter.

Syntax

Parameters.Delete Index

Parameter	Description
Index	A String value that contains the name of the object you want to delete, or the object's ordinal position (index) in the collection.

Remarks:
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.

Example

objCommand.Parameters.Delete 3