Using TDbQuery class

The design of this class is chosen so that the descriptor containing the SQL can be passed in the place of the TDbQuery object, which will be implicitly constructed with normal text comparison. So given

TPtrC sql=_L("select * from Personnel where Name like 'A*'");
RDbView view;

Then

view.Prepare(database,sql);

is equivalent to

view.Prepare(database,TDbQuery(sql,EDbCompareNormal));

To specify any other comparison type, the query object must be explicitly constructed:

view.Prepare(database,TDbQuery(sql,EDbCompareFolded));