1 <?xml version="1.0" encoding="utf-8"?>

     2 <!-- Copyright (c) 2007-2010 Nokia Corporation and/or its subsidiary(-ies) All rights reserved. -->

     3 <!-- This component and the accompanying materials are made available under the terms of the License 

     4 "Eclipse Public License v1.0" which accompanies this distribution, 

     5 and is available at the URL "http://www.eclipse.org/legal/epl-v10.html". -->

     6 <!-- Initial Contributors:

     7     Nokia Corporation - initial contribution.

     8 Contributors: 

     9 -->

    10 <!DOCTYPE concept

    11   PUBLIC "-//OASIS//DTD DITA Concept//EN" "concept.dtd">

    12 <concept id="GUID-8D130FC5-3AB8-5C70-A9D2-C753957E729F" xml:lang="en"><title>Basics:

    13 demonstrates basic use of the Symbian platform DBMS</title><prolog><metadata><keywords/></metadata></prolog><conbody>

    14 <section><title>Description</title> <p>This is an example of database manipulation

    15 using the DBMS. </p> <p>Initially the database is created as a permanent file

    16 store, using <codeph>CFileStore</codeph> routines. A table ("CDs") is created

    17 with three fields ("Artist", "Title" and "Price") and this is then indexed

    18 on the "Artist" and "Title" fields. </p> <p>To prove the correct action of

    19 the previous code, the example iterates through the database, printing the

    20 contents to the console. Finally, the database is closed and

    21 the example exits. </p> </section>

    22 <section><title>Download</title> <p>Download the example: <xref href="guid-6013a680-57f9-415b-8851-c4fa63356636/zips/guid-36e49706-602c-4aee-91d3-5083679e1d3d.zip" scope="external">Basics.zip</xref> </p><p>Download some additional files required

    23 by the example: <xref href="guid-6013a680-57f9-415b-8851-c4fa63356636/zips/guid-89fa6105-e749-4e5f-a233-a000e3b9390b.zip" scope="external">CommonFramework.zip</xref></p><p>View the source code: <xref href="guid-6013a680-57f9-415b-8851-c4fa63356636/guid-36e49706-602c-4aee-91d3-5083679e1d3d.html" scope="peer">browse</xref>. View the additional files: <xref href="guid-6013a680-57f9-415b-8851-c4fa63356636/guid-89fa6105-e749-4e5f-a233-a000e3b9390b.html" scope="peer">browse</xref></p> </section>

    24 <section><title>Usage</title> <p>The example should be run from the command

    25 line with no parameters. </p> </section>

    26 <section><title>Class summary</title><ul>

    27 <li><p><xref href="GUID-AE1BEF00-5AA7-3F03-95B0-9E40395EDA6C.dita"><apiname>RDbView</apiname></xref> - Generates rowsets from an SQL query. The

    28 query is prepared and evaluated using the interface to this class, while the

    29 rowset is manipulated using the RDbRowset base class.</p></li>

    30 <li><p><xref href="GUID-F4A68645-2265-307F-B951-8295827E000B.dita"><apiname>RDbStoreDatabase</apiname></xref> - DBMS Store database implementation.</p></li>

    31 <li><p><xref href="GUID-0130C7AA-B143-32A4-BB33-0D90CEDABAAE.dita"><apiname>TDbCol</apiname></xref> - Defines a column in a table or rowset.</p></li>

    32 <li><p><xref href="GUID-DDB34DBF-4A96-3430-820A-97AB5585962D.dita"><apiname>TDbKeyCol</apiname></xref> - Defines a key column in an index.</p></li>

    33 <li><p><xref href="GUID-9B02D75E-1EE0-349E-9900-BEC1CAF9DECE.dita"><apiname>CDbColSet</apiname></xref> - Manages a set of column definitions

    34 which describe a table or rowset structure. Column definitions can be added

    35 and removed. The set can be iterated over, and ordinals for a column can be

    36 looked up.</p></li>

    37 <li><p><xref href="GUID-F861EB8F-F621-3E77-8F9A-5E4EFC4E9C2F.dita"><apiname>RDbRowSet</apiname></xref> - An abstract base class that provides

    38 functionality which is shared between SQL view objects and Table objects.</p></li>

    39 <li><p><xref href="GUID-0CA88018-0265-3853-AC64-3B938DD0F60C.dita"><apiname>CDbKey</apiname></xref> - Represents the definition of an index. </p></li>

    40 <li><p><xref href="GUID-E79A3B03-F8CB-37DB-A2A8-1C6C4E4D739A.dita"><apiname>TParse</apiname></xref></p></li>

    41 <li><p><xref href="GUID-1C4D4AFD-85E2-3D5D-B704-D1FA0E5E7DA2.dita"><apiname>TStreamId</apiname></xref> - Provides unique identification for stream

    42 within a store.</p></li>

    43 <li><p><xref href="GUID-9CBA8AB1-5BFC-3719-82AF-22A9BD93C306.dita"><apiname>CFileStore</apiname></xref> - File based persistent store abstract

    44 base class.</p></li>

    45 </ul></section>

    46 </conbody></concept>