Using TDbQuery class

Explains how to use the 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));