Parameter Object (DAO)

Microsoft DAO 3.60

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.