Symbian3/SDK/Source/GUID-5FB2141F-8B2F-5DAE-8FDF-58D7351C5848.dita
changeset 0 89d6a7a84779
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Symbian3/SDK/Source/GUID-5FB2141F-8B2F-5DAE-8FDF-58D7351C5848.dita	Thu Jan 21 18:18:20 2010 +0000
@@ -0,0 +1,64 @@
+<?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 xml:lang="en" id="GUID-5FB2141F-8B2F-5DAE-8FDF-58D7351C5848"><title> Basic SQL Example: basicsqlexample.h </title><prolog><metadata><keywords/></metadata></prolog><conbody><p>A copy of the basicsqlexample.h file for the basic SQL example application. </p> <section><title>Introduction</title> <p>The program class and functions are declared in this file. </p> </section> <section><title>Code</title> <p>Declares the program structure. </p> <codeblock id="GUID-7022074F-62E3-5E4D-B776-C2287F4BAD08" xml:space="preserve">// basicsqlexample.h
+//
+// Copyright (c) Nokia Ltd 2009. All rights reserved.
+//
+
+/**
+@file
+Contains the CBasicSqlExample class.
+*/
+#ifndef __BASICSQLEXAMPLE_H__
+#define __BASICSQLEXAMPLE_H__
+
+#include &lt;e32base.h&gt; 
+/**
+Demonstrates some uses of Symbian OS SQL component.
+ 
+The class demonstrates how to 
+- Create a database
+- Populate a database
+- Query a database
+*/
+class CBasicSqlExample: public CBase
+    {
+public:
+    static CBasicSqlExample* NewLC();
+
+    ~CBasicSqlExample();
+    void ExampleL();
+    
+private:    // Utility/Basic Methods
+    void DoExampleL();
+    CBasicSqlExample();
+    void ConstructL();
+    void Prompt();
+    void Prompt(const TDesC&amp; aText);
+    
+private:    // Example Methods
+    void OpenDatabaseL();
+    void SqlQueryL(const TDesC&amp; aStatement);
+    void CloseDatabase();
+    
+    void DeleteDatabase();
+    void CreateDatabaseL();
+    void PopulateDatabaseL();
+    
+private:
+    RSqlDatabase iPetDb;
+
+    /** Pointer to the console interface */
+    CConsoleBase* iConsole;
+    };
+
+#endif //__BASICSQLEXAMPLE_H__</codeblock> </section> </conbody></concept>
\ No newline at end of file