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.