A Parameter object represents a value supplied to a query. The parameter is associated with a QueryDef object created from a parameter query.
Remarks
Parameter objects allow you to change the arguments in a frequently run QueryDef object without having to recompile the query.
Using the properties of a Parameter object, you can set a query parameter that can be changed before the query is run. You can:
| ? | Use the Name property to return the name of a parameter. |
| ? | Use the Value property to set or return the parameter values to be used in the query. |
| ? | Use the Type property to return the data type of the Parameter object. |
| ? | Use the Direction property to set or return whether the parameter is an input parameter, an output parameter, or both. |
In an ODBCDirect workspace, you can also:
| ? | Change the setting of the Type property. Doing so will also clear the Value property. |
| ? | Use the Direction property to set or return whether the parameter is an input parameter, an output parameter, or both. |