CreateParameter Method

Creates a new Parameter object with the specified properties.

Syntax

Set parameter = command.CreateParameter(Name, Type, Direction, Size, Value)

The CreateParameter method syntax has these parts:

Remarks

Use the CreateParameter method to create a new Parameter object with the specified name, type, direction, and value. Any values you pass in the arguments are written to the corresponding Parameter properties.

This method does not automatically append the Parameter object to the Parameters collection of a Command object. This lets you set additional properties whose values ADO will validate when you append the Parameter object to the collection.

If you specify a variable-length data type in the Type argument, you must either pass a Size argument or set the Size property of the Parameter object before appending it to the Parameters collection; otherwise, an error occurs.

Applies To

Command

See Also

Append, Parameter, Parameters