CdbParameter Object

      Properties

A CdbParameter object represents a value supplied to a query. The parameter is associated with a CdbQueryDef object created from a parameter query.



Remarks

CdbParameter objects allow you to change the arguments in a frequently run CdbQueryDef object without having to recompile the query.

Using the properties of a CdbParameter object, you can set a query parameter that can be changed before the query is run. You can:

In an ODBCDirect workspace, you can also:

CdbParameter Constructor Syntax

Use any one of the following three constructors. The qualifier 'CONSTRUCTOR' in the syntax models is provided to help readability. It has no syntactic value.

CONSTRUCTORCdbParameter(VOID);

This constructor creates an instance of the class. There are no parameters.

CONSTRUCTORCdbParameter(const CdbParameter &);

Type Description
const CdbParameter & Reference to an object.

This constructor creates a copy of the object referenced in the parameter.

CONSTRUCTORCdbParameter(DAOParameter *pprm,

BOOL bAddRef = FALSE);

Type Argument Description
DAOParameter * pprm A DAO Automation interface pointer corresponding to this DAO class.
BOOL bAddRef

=FALSE

Optional. A Boolean. If TRUE, the DAO Automation interface AddRef function is called.

DAO functionality is presented through pointers to DAO Automation interfaces. This constructor makes a DAO interface available in the form of a DAO class object that provides additional functionality.

This constructor is not required for typical use. It is provided to enable you to easily create a DAO class object if you have access to the corresponding DAO interface.

When the destructor for the DAO object is invoked, the underlying Automation interface's Release member is called. If Release decrements the interface's reference count to zero, the pointer to the Automation interface can be deleted. If you don't want this to happen (for example, because you want to discard the DAO object, but continue using the Automation interface), specify TRUE for the second parameter. The underlying Automation interface's AddRef member is called, which counterbalances the eventual call to Release.