<?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 task

  PUBLIC "-//OASIS//DTD DITA Task//EN" "task.dtd">

<task id="GUID-200647EF-B9CA-5EEA-8760-71A9C1B063CE" xml:lang="en"><title>SQL

Tutorial</title><shortdesc>This tutorial set shows you how to perform many of the most common

Symbian SQL tasks. </shortdesc><prolog><metadata><keywords/></metadata></prolog><taskbody>

<prereq id="GUID-2774F7AC-B5CD-5539-9D7C-7721BD6ACCEE"><p>Before you start,

you must: </p> <ul>

<li id="GUID-F0C9936C-D1E3-50B4-9500-3AF766E5848D"><p>Review the code from

the <xref href="GUID-C2FCE726-FD87-52BF-8AF8-7F54FB6D6CB1.dita">Basic SQL example

application</xref>. </p> </li>

<li id="GUID-9A1F5841-42A1-5549-B1B1-2A8FF68217D7"><p>Be familiar with SQLite

3. </p> </li>

</ul> </prereq>

<context id="GUID-4189BBC8-D9A6-54AC-8294-01B85E213C04"><p>The tutorials in

this set introduce you to the basic tasks involved in creating an SQL aware

or capable application for a Symbian platform device. </p> </context>

<steps id="GUID-3D018462-88E6-57D4-8707-5B66ED333632">

<step id="GUID-B28CE62D-4063-50EF-8942-7311947DA24B"><cmd/>

<info> <xref href="GUID-B38EBDBA-2A30-5595-9639-6AE58C530DCB.dita">Creating a Database</xref> </info>

</step>

<step id="GUID-446C2F25-796B-5B35-B5BA-77B33623DE0A"><cmd/>

<info> <xref href="GUID-1D35F788-A470-5269-93E0-7C33A0013489.dita">Creating a Table</xref>  </info>

</step>

<step id="GUID-D9BE05D7-FFC9-523E-9229-FDD66EFB6510"><cmd/>

<info> <xref href="GUID-2610E11C-26FA-538E-A3E1-34AADA35F20B.dita">Querying Databases:

Basic</xref> </info>

</step>

<step id="GUID-7DFEE192-8A0C-5BA5-9A93-B486FF00F40F"><cmd/>

<info> <xref href="GUID-C60DAE3D-7FB9-5619-9E5D-476A430705AF.dita">Querying the

Database</xref>  </info>

</step>

<step id="GUID-3AE3B077-BD2F-5602-86CD-66B0B5D9D517"><cmd/>

<info> <xref href="GUID-B61EA8C5-0966-51DE-AC73-01DD34C7D3CC.dita">Deleting Data

from the Table</xref>  </info>

</step>

<step id="GUID-FA211396-616B-5016-ADBB-C1985BE329ED"><cmd/>

<info> <xref href="GUID-183280EE-0C57-54FE-8ABB-E1CC3BDE525B.dita">Reading to a

Data Stream</xref> </info>

</step>

<step id="GUID-51810361-2261-564A-9E87-AB786C27C469"><cmd/>

<info> <xref href="GUID-72511204-FC90-54AA-9E2E-833318020318.dita">Reading to a

Buffer</xref> </info>

</step>

<step id="GUID-F97C2A80-6C3F-532C-BE1D-20963D270D3B"><cmd/>

<info> <xref href="GUID-3CCA6503-54DA-5558-85DC-93A22A81F565.dita"> Reading to

Memory </xref> </info>

</step>

<step id="GUID-912FF38F-F6FF-579E-B266-98DEBE9D6D41"><cmd/>

<info> <xref href="GUID-B9A3B17E-BDEB-5F66-968C-080335A721AC.dita">Writing to a

Data Stream</xref> </info>

</step>

<step id="GUID-2863BF0C-F569-597E-A841-DCEDE91AE7C2"><cmd/>

<info> <xref href="GUID-CCB9C61B-FB28-5CD9-A366-4A9584097897.dita">Inserting a

Row into a Table</xref> </info>

</step>

<step id="GUID-00A5C4F3-88BE-5602-9F93-246CE7408935"><cmd/>

<info> <xref href="GUID-C474376E-1766-5781-B5BF-3786C5B4D72E.dita">Performing Scalar

Queries</xref>  </info>

</step>

</steps>

</taskbody><related-links>

<link href="GUID-22844C28-AB5B-5A6F-8863-7269464684B4.dita"><linktext>SQL Overview</linktext>

</link>

<link href="GUID-C2FCE726-FD87-52BF-8AF8-7F54FB6D6CB1.dita"><linktext>Basic SQL

Example                 Application</linktext></link>