ADO Parameter Object
Parameter Object
ADO Parameter object can be used to provide information about the stored procedure or query a single parameter.
Parameter objects are added when it is created in the Parameters collection. Parameters set with a specific Command object associated, Command object uses this collection to pass parameters in stored procedures and queries inside and outside.
Parameter is used to create a parameterized command. These commands (after they have been defined and stored) using the parameters in the command to execute commands to change some details. For example, SQL SELECT statement can be used to define the parameters match the WHERE clause, and to define the name of the column SORT BY clauses use another parameter.
There are four types of parameters: input parameters, output parameters, input / output parameters and return parameters.
grammar
Attributes
Attributes | description |
---|---|
Attributes | Sets or returns the property of a Parameter object. |
Direction | Sets or returns how to pass a parameter to a stored procedure or passed back from a stored procedure. |
Name | Sets or returns the name of a Parameter object. |
NumericScale | The number of digits to the right of the setting or returns a Parameter object values. |
Precision | Sets or returns when the maximum number allowed when a parameter value represents the number. |
Size | Sets or returns the Parameter object for the maximum size (in bytes or characters). |
Type | Sets or returns the type of a Parameter object. |
Value | Sets or returns the value of a Parameter object. |
method
method | description |
---|---|
AppendChunk | The additional long binary or character data to a Parameter object. |
Delete | To delete an object from the Parameters collection. |