ADO Parameter Object

Parameter object

The ADO Parameter object can provide information about a single parameter used in a stored procedure or query.

The Parameter object is added to the Parameters collection when it is created. The Parameters collection is associated with a specific Command object, which uses this collection to pass parameters inside and outside of stored procedures and queries.

Parameters are used to create parameterized commands. These commands (after they have been defined and stored) use parameters to change some details of the command before execution. For example, the SQL SELECT statement can use parameters to define the matching conditions of the WHERE clause, and another parameter to define the column name of the SORT BY clause.

There are four types of parameters: input parameters, output parameters, input/output parameters, and return parameters.

Grammar

objectname.property
objectname.method

Properties

Properties Description
Attributes Set or return the attributes of a Parameter object.
Direction Set or return how a parameter is passed to or returned from a stored procedure.
Name Set or return the name of a Parameter object.
NumericScale Set or return the number of digits to the right of the decimal point of a numeric value in a Parameter object.
Precision Set or return the maximum number of digits allowed when representing a numeric value in a parameter.
Size Set or return the maximum size of the value in a Parameter object (in bytes or characters).
Type Set or return the type of a Parameter object.
Value Set or return the value of a Parameter object.

Method

Method Description
AppendChunk Append long binary or character data to a Parameter object.
Delete Remove an object from the Parameters collection.