Parameter Object
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.