<?xml version="1.0" encoding="utf-8"?>
<!-- Copyright (c) 2007-2010 Nokia Corporation and/or its subsidiary(-ies) All rights reserved. -->
<!-- This component and the accompanying materials are made available under the terms of the License 
"Eclipse Public License v1.0" which accompanies this distribution, 
and is available at the URL "http://www.eclipse.org/legal/epl-v10.html". -->
<!-- Initial Contributors:
    Nokia Corporation - initial contribution.
Contributors: 
-->
<!DOCTYPE concept
  PUBLIC "-//OASIS//DTD DITA Concept//EN" "concept.dtd">
<concept id="GUID-05DA872F-F70E-5085-8AA9-12B6A0B71917" xml:lang="en"><title>Using
TDbQuery class</title><shortdesc>Explains how to use the <codeph>TDbQuery</codeph> class.</shortdesc><prolog><metadata><keywords/></metadata></prolog><conbody>
<p>The design of this class is chosen so that the descriptor containing the
SQL can be passed in the place of the <codeph>TDbQuery</codeph> object, which
will be implicitly constructed with normal text comparison. So given</p>
<codeblock id="GUID-5CE628CD-6B02-570B-8C08-858455D2E694" xml:space="preserve">TPtrC sql=_L("select * from Personnel where Name like 'A*'");
RDbView view;</codeblock>
<p>Then</p>
<codeblock id="GUID-152661DA-ACC2-57E5-AA4E-252A8FF42E89" xml:space="preserve">view.Prepare(database,sql);</codeblock>
<p>is equivalent to</p>
<codeblock id="GUID-F0E34B77-A117-58E9-9CDE-3AB22289DE31" xml:space="preserve">view.Prepare(database,TDbQuery(sql,EDbCompareNormal));</codeblock>
<p>To specify any other comparison type, the query object must be explicitly
constructed:</p>
<codeblock id="GUID-7386D1EC-7611-5C1F-BC11-F826396D6D12" xml:space="preserve">view.Prepare(database,TDbQuery(sql,EDbCompareFolded));</codeblock>
</conbody></concept>