Class TDbQuery

TDbQuery

Support

Supported from 5.0

Description

A wrapper for an SQL string combined with a text comparison mode.

An instance of the class is used as a parameter to RDbView::Prepare(), RDbRowSet::FindL() and RDbRowConstraint::Open().

The evaluation of SQL queries or constraints depends on how Text columns are compared — so every SQL string is accompanied by a member of the TDbTextComparison enumeration to indicate how comparison is done.

Defined in TDbQuery:
Comparison(), Query(), TDbQuery()

See also:

• TDbTextComparison
• RDbView::Prepare()
• RDbRowSet::FindL()
• RDbRowConstraint::Open()
• Using TDbQuery class

TDbQuery(const TDesC& aQuery,TDbTextComparison aComparison=EDbCompareNormal);

Description

Constructs a query object from an SQL string and a text comparison mode.

Note that no copy is made of the descriptor passed; it is stored by reference in the query object.

Parameters

const TDesC& aQuery The SQL string as a descriptor. TDbTextComparison aComparison The type of text comparison to use in evaluation of the SQL. If not supplied, normal comparison is used.

TDbTextComparison Comparison() const;

Description

Returns the text comparison mode for the query object.

Return value

TDbTextComparison The text comparison mode.

const TDesC& Query() const;

Description

Returns the SQL string in the query object.

Return value

TDesC& A descriptor containing the SQL string.