Symbian3/Examples/guid-6013a680-57f9-415b-8851-c4fa63356636/sqlexample_8cpp_source.html
Week 32 contribution of PDK documentation content. See release notes for details. Fixes bug Bug 3582
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<title>TB9.2 Example Applications: examples/SysLibs/SqlExample/sqlexample.cpp Source File</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="doxygen.css" rel="stylesheet" type="text/css"/>
</head>
<body>
<!-- Generated by Doxygen 1.6.2 -->
<h1>examples/SysLibs/SqlExample/sqlexample.cpp</h1><a href="sqlexample_8cpp.html">Go to the documentation of this file.</a><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 <span class="comment">// Copyright (c) 2006-2009 Nokia Corporation and/or its subsidiary(-ies).</span>
<a name="l00002"></a>00002 <span class="comment">// All rights reserved.</span>
<a name="l00003"></a>00003 <span class="comment">// This component and the accompanying materials are made available</span>
<a name="l00004"></a>00004 <span class="comment">// under the terms of "Eclipse Public License v1.0"</span>
<a name="l00005"></a>00005 <span class="comment">// which accompanies this distribution, and is available</span>
<a name="l00006"></a>00006 <span class="comment">// at the URL "http://www.eclipse.org/legal/epl-v10.html".</span>
<a name="l00007"></a>00007 <span class="comment">//</span>
<a name="l00008"></a>00008 <span class="comment">// Initial Contributors:</span>
<a name="l00009"></a>00009 <span class="comment">// Nokia Corporation - initial contribution.</span>
<a name="l00010"></a>00010 <span class="comment">//</span>
<a name="l00011"></a>00011 <span class="comment">// Contributors:</span>
<a name="l00012"></a>00012 <span class="comment">//</span>
<a name="l00013"></a>00013 <span class="comment">// Description:</span>
<a name="l00014"></a>00014 <span class="comment">// This example program demonstrates the use of SQL APIs. </span>
<a name="l00015"></a>00015 <span class="comment">// The code demonstrates how to create non secure and secure databases on </span>
<a name="l00016"></a>00016 <span class="comment">// the writable drive and perform basic operations on the databases.</span>
<a name="l00017"></a>00017 <span class="comment">//</span>
<a name="l00018"></a>00018
<a name="l00019"></a>00019
<a name="l00020"></a>00020
<a name="l00024"></a>00024 <span class="preprocessor">#include "<a class="code" href="sqlexample_8h.html">sqlexample.h</a>"</span>
<a name="l00025"></a>00025 <span class="preprocessor">#include <e32cons.h></span>
<a name="l00026"></a>00026 <span class="preprocessor">#include <sqldb.h></span>
<a name="l00027"></a>00027
<a name="l00028"></a>00028 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KTitle, <span class="stringliteral">"SQL example"</span>);
<a name="l00029"></a>00029 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KTextPressAKey, <span class="stringliteral">"\n\nPress any key to step through the example\n"</span>);
<a name="l00030"></a>00030 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KExit,<span class="stringliteral">"Press any key to exit the application "</span>);
<a name="l00031"></a>00031 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KPressAKey,<span class="stringliteral">"Press any key to continue \n"</span>);
<a name="l00032"></a>00032 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KNonSecure,<span class="stringliteral">"\nCreating a non secure database \n"</span>);
<a name="l00033"></a>00033 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSecure,<span class="stringliteral">"\nCreating a secure database \n"</span>);
<a name="l00034"></a>00034 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KOpen,<span class="stringliteral">"Opening the secure database \n"</span>);
<a name="l00035"></a>00035 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KDelete,<span class="stringliteral">"Deleting the database(s)\n"</span>);
<a name="l00036"></a>00036 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KClose,<span class="stringliteral">"Closing the database(s)\n"</span>);
<a name="l00037"></a>00037 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KCopyNonSec,<span class="stringliteral">"\nCopying a non secure database to another non secure one \n"</span>);
<a name="l00038"></a>00038 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KCopySecure,<span class="stringliteral">"\nCopying a secure database to another secure database \n"</span>);
<a name="l00039"></a>00039 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KAttach,<span class="stringliteral">"\nOpen a secure database and attach another secure database\n"</span>);
<a name="l00040"></a>00040 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KCreateTable,<span class="stringliteral">"\nCreating a table\n"</span>);
<a name="l00041"></a>00041 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KInsert,<span class="stringliteral">"Inserting records into the table\n"</span>);
<a name="l00042"></a>00042 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KPrepare,<span class="stringliteral">"Preparing a query\n"</span>);
<a name="l00043"></a>00043 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KExecute,<span class="stringliteral">"Executing a query\n"</span>);
<a name="l00044"></a>00044
<a name="l00045"></a>00045 <span class="comment">// Names of the databases created, operated upon and later deleted.</span>
<a name="l00046"></a>00046 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KDbName, <span class="stringliteral">"\\Example_db.db"</span>);
<a name="l00047"></a>00047 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KAnotherDbName, <span class="stringliteral">"\\Example_Anotherdb.db"</span>);
<a name="l00048"></a>00048 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSecureDb1, <span class="stringliteral">"[E80000AF]db1.db"</span>);
<a name="l00049"></a>00049 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSecureDb2, <span class="stringliteral">"[E80000AF]db2.db"</span>);
<a name="l00050"></a>00050 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KDatabase, <span class="stringliteral">"\\Sqlscalarfullselect.db"</span>);
<a name="l00051"></a>00051
<a name="l00052"></a>00052 <span class="comment">// Security policies used</span>
<a name="l00053"></a>00053 <span class="keyword">const</span> TSecurityPolicy KPolicy1(ECapabilityReadUserData, ECapabilityNetworkControl, ECapabilityWriteUserData);
<a name="l00054"></a>00054 <span class="keyword">const</span> TSecurityPolicy KPolicy2(ECapabilityReadUserData);
<a name="l00055"></a>00055
<a name="l00061"></a><a class="code" href="class_c_sql_example.html#a8b115210a3fbfa19de5c7f6a0abf3e43">00061</a> <a class="code" href="class_c_sql_example.html">CSqlExample</a>* <a class="code" href="class_c_sql_example.html#a8b115210a3fbfa19de5c7f6a0abf3e43">CSqlExample::NewLC</a>()
<a name="l00062"></a>00062 {
<a name="l00063"></a>00063 <a class="code" href="class_c_sql_example.html">CSqlExample</a>* rep = <span class="keyword">new</span>(ELeave) <a class="code" href="class_c_sql_example.html">CSqlExample</a>();
<a name="l00064"></a>00064 CleanupStack::PushL(rep);
<a name="l00065"></a>00065 rep->ConstructL();
<a name="l00066"></a>00066 <span class="keywordflow">return</span> rep;
<a name="l00067"></a>00067 }
<a name="l00068"></a>00068
<a name="l00072"></a>00072 CSqlExample::CSqlExample()
<a name="l00073"></a>00073 {
<a name="l00074"></a>00074 }
<a name="l00075"></a>00075
<a name="l00076"></a>00076 <span class="keywordtype">void</span> CSqlExample::ConstructL()
<a name="l00077"></a>00077 {
<a name="l00078"></a>00078 iConsole = Console::NewL(KTitle,TSize(KConsFullScreen,KConsFullScreen));
<a name="l00079"></a>00079 iConsole->Printf ( KTextPressAKey );
<a name="l00080"></a>00080 iConsole->Getch ();
<a name="l00081"></a>00081 }
<a name="l00082"></a>00082
<a name="l00086"></a><a class="code" href="class_c_sql_example.html#a81cffca804968549ed3523230f28408f">00086</a> <a class="code" href="class_c_sql_example.html#a81cffca804968549ed3523230f28408f">CSqlExample::~CSqlExample</a>()
<a name="l00087"></a>00087 {
<a name="l00088"></a>00088 iConsole->Printf(KExit);
<a name="l00089"></a>00089 iConsole->Getch();
<a name="l00090"></a>00090
<a name="l00091"></a>00091 <span class="keyword">delete</span> iConsole;
<a name="l00092"></a>00092 }
<a name="l00093"></a>00093
<a name="l00100"></a><a class="code" href="class_c_sql_example.html#af0523fb9c7a711a2c7745e8d2e96faa7">00100</a> <span class="keywordtype">void</span> <a class="code" href="class_c_sql_example.html#af0523fb9c7a711a2c7745e8d2e96faa7">CSqlExample::CreateNonSecureDBL</a>()
<a name="l00101"></a>00101 {
<a name="l00102"></a>00102 TBuf<200> buffer;
<a name="l00103"></a>00103 RSqlDatabase db;
<a name="l00104"></a>00104
<a name="l00105"></a>00105 <span class="comment">// Create non-secure database</span>
<a name="l00106"></a>00106 iConsole->Printf(KNonSecure);
<a name="l00107"></a>00107 TInt error;
<a name="l00108"></a>00108 TRAP(error,db.Create(KDbName););
<a name="l00109"></a>00109
<a name="l00110"></a>00110 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KTable,<span class="stringliteral">"CREATE TABLE A1(F1 INTEGER, F2 INTEGER)"</span>);
<a name="l00111"></a>00111 User::LeaveIfError(error = db.Exec(KTable));
<a name="l00112"></a>00112
<a name="l00113"></a>00113 db.Close();
<a name="l00114"></a>00114 iConsole->Printf(KClose);
<a name="l00115"></a>00115 iConsole->Printf(KPressAKey);
<a name="l00116"></a>00116 iConsole->Getch();
<a name="l00117"></a>00117 }
<a name="l00118"></a>00118
<a name="l00127"></a><a class="code" href="class_c_sql_example.html#a2d2358e96bba71900cedd067fe44192b">00127</a> <span class="keywordtype">void</span> <a class="code" href="class_c_sql_example.html#a2d2358e96bba71900cedd067fe44192b">CSqlExample::CreateAndOpenSecureDBL</a>()
<a name="l00128"></a>00128 {
<a name="l00129"></a>00129 RSqlDatabase db;
<a name="l00130"></a>00130 RSqlSecurityPolicy securityPolicy;
<a name="l00131"></a>00131
<a name="l00132"></a>00132 User::LeaveIfError(securityPolicy.Create(TSecurityPolicy(TSecurityPolicy::EAlwaysPass)));
<a name="l00133"></a>00133 User::LeaveIfError(securityPolicy.SetDbPolicy(RSqlSecurityPolicy::EWritePolicy, KPolicy1));
<a name="l00134"></a>00134
<a name="l00135"></a>00135 iConsole->Printf(KSecure);
<a name="l00136"></a>00136 User::LeaveIfError(db.Create(KSecureDb1, securityPolicy));
<a name="l00137"></a>00137
<a name="l00138"></a>00138 securityPolicy.Close();
<a name="l00139"></a>00139
<a name="l00140"></a>00140 <span class="comment">// Check that the database security policy matches the policy used </span>
<a name="l00141"></a>00141 <span class="comment">//when the database was created.</span>
<a name="l00142"></a>00142 User::LeaveIfError(db.GetSecurityPolicy(securityPolicy));
<a name="l00143"></a>00143
<a name="l00144"></a>00144 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSecureCreate,<span class="stringliteral">"CREATE TABLE secure(int_fld integer, null_int_fld integer default null)"</span>);
<a name="l00145"></a>00145 User::LeaveIfError(db.Exec(KSecureCreate));
<a name="l00146"></a>00146
<a name="l00147"></a>00147 <span class="comment">// Attempt to write to the secure database</span>
<a name="l00148"></a>00148 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSecureInsert,<span class="stringliteral">"INSERT INTO secure(int_fld) values(200)"</span>);
<a name="l00149"></a>00149 User::LeaveIfError(db.Exec(KSecureInsert));
<a name="l00150"></a>00150 db.Close();
<a name="l00151"></a>00151
<a name="l00152"></a>00152 iConsole->Printf(KOpen);
<a name="l00153"></a>00153 <span class="comment">// Open the secure database </span>
<a name="l00154"></a>00154 User::LeaveIfError(db.Open(KSecureDb1));
<a name="l00155"></a>00155
<a name="l00156"></a>00156 db.Close();
<a name="l00157"></a>00157 iConsole->Printf(KClose);
<a name="l00158"></a>00158 iConsole->Printf(KPressAKey);
<a name="l00159"></a>00159 iConsole->Getch();
<a name="l00160"></a>00160 securityPolicy.Close();
<a name="l00161"></a>00161
<a name="l00162"></a>00162 }
<a name="l00163"></a>00163
<a name="l00171"></a><a class="code" href="class_c_sql_example.html#a1a6247133748297a2a8877381583e51c">00171</a> <span class="keywordtype">void</span> <a class="code" href="class_c_sql_example.html#a1a6247133748297a2a8877381583e51c">CSqlExample::CopyDatabaseL</a>()
<a name="l00172"></a>00172 {
<a name="l00173"></a>00173 RSqlDatabase db;
<a name="l00174"></a>00174
<a name="l00175"></a>00175 <span class="comment">// Copy non-secure to non-secure database</span>
<a name="l00176"></a>00176 iConsole->Printf(KCopyNonSec);
<a name="l00177"></a>00177 User::LeaveIfError(RSqlDatabase::Copy(KDbName, KAnotherDbName));
<a name="l00178"></a>00178
<a name="l00179"></a>00179 <span class="comment">// Delete the source database</span>
<a name="l00180"></a>00180 iConsole->Printf(KDelete);
<a name="l00181"></a>00181 User::LeaveIfError(RSqlDatabase::Delete(KAnotherDbName));
<a name="l00182"></a>00182
<a name="l00183"></a>00183 <span class="comment">// Create another secure database with a different security policy,</span>
<a name="l00184"></a>00184 <span class="comment">// KSecureDb1 is already created with KPolicy1.</span>
<a name="l00185"></a>00185 RSqlSecurityPolicy securityPolicy;
<a name="l00186"></a>00186 User::LeaveIfError(securityPolicy.Create(TSecurityPolicy(TSecurityPolicy::EAlwaysPass)));
<a name="l00187"></a>00187
<a name="l00188"></a>00188 User::LeaveIfError(securityPolicy.SetDbPolicy(RSqlSecurityPolicy::EWritePolicy, KPolicy2));
<a name="l00189"></a>00189
<a name="l00190"></a>00190 User::LeaveIfError(db.Create(KSecureDb2, securityPolicy));
<a name="l00191"></a>00191
<a name="l00192"></a>00192 User::LeaveIfError(db.GetSecurityPolicy(securityPolicy));
<a name="l00193"></a>00193 db.Close();
<a name="l00194"></a>00194
<a name="l00195"></a>00195 <span class="comment">// Copy secure to secure database. The application is the database owner.</span>
<a name="l00196"></a>00196 iConsole->Printf(KCopySecure);
<a name="l00197"></a>00197 User::LeaveIfError(RSqlDatabase::Copy(KSecureDb1, KSecureDb2));
<a name="l00198"></a>00198
<a name="l00199"></a>00199 <span class="comment">// Delete the source database</span>
<a name="l00200"></a>00200 iConsole->Printf(KDelete);
<a name="l00201"></a>00201 User::LeaveIfError(RSqlDatabase::Delete(KSecureDb1));
<a name="l00202"></a>00202
<a name="l00203"></a>00203 iConsole->Printf(KPressAKey);
<a name="l00204"></a>00204 iConsole->Getch();
<a name="l00205"></a>00205 securityPolicy.Close();
<a name="l00206"></a>00206 db.Close();
<a name="l00207"></a>00207
<a name="l00208"></a>00208 }
<a name="l00209"></a>00209
<a name="l00217"></a><a class="code" href="class_c_sql_example.html#adf02168d537e9e1650d5f379522a6b2e">00217</a> <span class="keywordtype">void</span> <a class="code" href="class_c_sql_example.html#adf02168d537e9e1650d5f379522a6b2e">CSqlExample::AttachDatabasesL</a>()
<a name="l00218"></a>00218 {
<a name="l00219"></a>00219 RSqlDatabase db;
<a name="l00220"></a>00220 RSqlSecurityPolicy securityPolicy;
<a name="l00221"></a>00221
<a name="l00222"></a>00222 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KAttachDb2, <span class="stringliteral">"Db2"</span>);
<a name="l00223"></a>00223
<a name="l00224"></a>00224 User::LeaveIfError(db.Open(KSecureDb2));
<a name="l00225"></a>00225 iConsole->Printf(KAttach);
<a name="l00226"></a>00226
<a name="l00227"></a>00227 User::LeaveIfError(db.Attach(KDbName, KAttachDb2));
<a name="l00228"></a>00228
<a name="l00229"></a>00229 <span class="comment">// Attempt to write to the attached non secure database</span>
<a name="l00230"></a>00230 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KTabInsert,<span class="stringliteral">"INSERT INTO db2.a1(f1) valUES(10)"</span>);
<a name="l00231"></a>00231 User::LeaveIfError(db.Exec(KTabInsert));
<a name="l00232"></a>00232
<a name="l00233"></a>00233 <span class="comment">// Attempt to read from the attached non secure database</span>
<a name="l00234"></a>00234 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSelect,<span class="stringliteral">"SELECT * FROM db2.a1"</span>);
<a name="l00235"></a>00235 User::LeaveIfError(db.Exec(KSelect));
<a name="l00236"></a>00236
<a name="l00237"></a>00237 <span class="comment">// Attempt to write to the main secure database</span>
<a name="l00238"></a>00238 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KAttachInsert,<span class="stringliteral">"INSERT INTO a1(f1) valUES(10)"</span>);
<a name="l00239"></a>00239 User::LeaveIfError(db.Exec(KAttachInsert));
<a name="l00240"></a>00240
<a name="l00241"></a>00241 db.Close();
<a name="l00242"></a>00242 iConsole->Printf(KDelete);
<a name="l00243"></a>00243 User::LeaveIfError(RSqlDatabase::Delete(KDbName));
<a name="l00244"></a>00244
<a name="l00245"></a>00245 User::LeaveIfError(RSqlDatabase::Delete(KSecureDb2));
<a name="l00246"></a>00246
<a name="l00247"></a>00247 securityPolicy.Close();
<a name="l00248"></a>00248
<a name="l00249"></a>00249 }
<a name="l00250"></a>00250
<a name="l00257"></a><a class="code" href="class_c_sql_example.html#a49067abc75f826bfd43be44c07460c7b">00257</a> <span class="keywordtype">void</span> <a class="code" href="class_c_sql_example.html#a49067abc75f826bfd43be44c07460c7b">CSqlExample:: DataTypesQueryL</a>()
<a name="l00258"></a>00258 {
<a name="l00259"></a>00259 RSqlDatabase db;
<a name="l00260"></a>00260 iConsole->Printf(KSecure);
<a name="l00261"></a>00261
<a name="l00262"></a>00262 User::LeaveIfError(db.Create(KDbName));
<a name="l00263"></a>00263
<a name="l00264"></a>00264 <span class="comment">// Create a table with different numeric field types</span>
<a name="l00265"></a>00265 iConsole->Printf(KCreateTable);
<a name="l00266"></a>00266 iConsole->Printf(KExecute);
<a name="l00267"></a>00267
<a name="l00268"></a>00268 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSql1, <span class="stringliteral">"CREATE TABLE Tbl(A INTEGER, B SMALLINT, C REAL, D DOUBLE PRECISION, E FLOAT, \</span>
<a name="l00269"></a>00269 <span class="stringliteral"> F DECIMAL)"</span>);
<a name="l00270"></a>00270 User::LeaveIfError(db.Exec(KSql1));
<a name="l00271"></a>00271
<a name="l00272"></a>00272 <span class="comment">// Insert one record in to the created table</span>
<a name="l00273"></a>00273 iConsole->Printf(KInsert);
<a name="l00274"></a>00274 iConsole->Printf(KExecute);
<a name="l00275"></a>00275
<a name="l00276"></a>00276 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSql2, <span class="stringliteral">"INSERT INTO Tbl(A,B,C,D,E,F) VALUES(2000000000, 30000, 123.45, 0.912E+55,\</span>
<a name="l00277"></a>00277 <span class="stringliteral"> 1.34E-14, 1234.5678)"</span>);
<a name="l00278"></a>00278 User::LeaveIfError(db.Exec(KSql2));
<a name="l00279"></a>00279
<a name="l00280"></a>00280 <span class="comment">// Get the inserted record data</span>
<a name="l00281"></a>00281 RSqlStatement stmt;
<a name="l00282"></a>00282 iConsole->Printf(KPrepare);
<a name="l00283"></a>00283
<a name="l00284"></a>00284 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KPrepQuery,<span class="stringliteral">"SELECT * FROM Tbl"</span>);
<a name="l00285"></a>00285 User::LeaveIfError(stmt.Prepare(db, KPrepQuery));
<a name="l00286"></a>00286
<a name="l00287"></a>00287 User::LeaveIfError(stmt.Next());
<a name="l00288"></a>00288 stmt.Close();
<a name="l00289"></a>00289
<a name="l00290"></a>00290 <span class="comment">// The statement object has to be closed before db.Exec() call, </span>
<a name="l00291"></a>00291 <span class="comment">// otherwise the reported error is "database table is locked"</span>
<a name="l00292"></a>00292 <span class="comment">// Insert second record in to the created table but inverse the column types.</span>
<a name="l00293"></a>00293 iConsole->Printf(KExecute);
<a name="l00294"></a>00294 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSql3, <span class="stringliteral">"INSERT INTO Tbl(A, B, C, D, E, F) VALUES(\</span>
<a name="l00295"></a>00295 <span class="stringliteral"> -2.5,1.1,12,23,45,111)"</span>);
<a name="l00296"></a>00296 User::LeaveIfError(db.Exec(KSql3));
<a name="l00297"></a>00297
<a name="l00298"></a>00298 <span class="comment">// Get the inserted record data</span>
<a name="l00299"></a>00299 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KPrepQuery2,<span class="stringliteral">"SELECT * FROM Tbl"</span>);
<a name="l00300"></a>00300 User::LeaveIfError(stmt.Prepare(db, KPrepQuery2));
<a name="l00301"></a>00301
<a name="l00302"></a>00302 User::LeaveIfError(stmt.Next());
<a name="l00303"></a>00303
<a name="l00304"></a>00304 stmt.Close();
<a name="l00305"></a>00305
<a name="l00306"></a>00306 <span class="comment">// Insert third record in to the created table</span>
<a name="l00307"></a>00307 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSql4, <span class="stringliteral">"INSERT INTO Tbl(A,B,C,D,E,F) VALUES(\</span>
<a name="l00308"></a>00308 <span class="stringliteral"> 2,3,123.45,1.5,2.5,1.56)"</span>);
<a name="l00309"></a>00309 User::LeaveIfError(db.Exec(KSql4));
<a name="l00310"></a>00310
<a name="l00311"></a>00311 stmt.Close();
<a name="l00312"></a>00312 db.Close();
<a name="l00313"></a>00313 User::LeaveIfError(RSqlDatabase::Delete(KDbName));
<a name="l00314"></a>00314 }
<a name="l00315"></a>00315
<a name="l00316"></a>00316
<a name="l00328"></a><a class="code" href="class_c_sql_example.html#a7fac459ccd95278c1af4eb50e5453812">00328</a> <span class="keywordtype">void</span> <a class="code" href="class_c_sql_example.html#a7fac459ccd95278c1af4eb50e5453812">CSqlExample::ScalarFullSelectL</a>()
<a name="l00329"></a>00329 {
<a name="l00330"></a>00330 RSqlDatabase db;
<a name="l00331"></a>00331 <span class="comment">//Create database.</span>
<a name="l00332"></a>00332 User::LeaveIfError(db.Create(KDatabase));
<a name="l00333"></a>00333
<a name="l00334"></a>00334 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KTabCreateA,<span class="stringliteral">"CREATE TABLE A(F1 INTEGER, F2 INTEGER, F3 FLOAT, F4 TEXT, F5 BLOB)"</span>);
<a name="l00335"></a>00335 User::LeaveIfError(db.Exec(KTabCreateA));
<a name="l00336"></a>00336
<a name="l00337"></a>00337 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KTabInsert1A,<span class="stringliteral">"INSERT INTO A(F1, F2, F3, F4, F5) VALUES(1, 10000000000, 2.54, 'NAME1234567890', NULL)"</span>);
<a name="l00338"></a>00338 User::LeaveIfError(db.Exec(KTabInsert1A));
<a name="l00339"></a>00339
<a name="l00340"></a>00340 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KTabInsert2A,<span class="stringliteral">"INSERT INTO A(F1, F2, F3, F4) VALUES(2, 200, -1.11, 'ADDRESS')"</span>);
<a name="l00341"></a>00341 User::LeaveIfError(db.Exec(KTabInsert2A));
<a name="l00342"></a>00342
<a name="l00343"></a>00343 RSqlStatement stmt;
<a name="l00344"></a>00344 CleanupClosePushL(stmt);
<a name="l00345"></a>00345
<a name="l00346"></a>00346 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KUpdate,<span class="stringliteral">"UPDATE A SET F5=:P WHERE F1 = 2"</span>);
<a name="l00347"></a>00347 User::LeaveIfError(stmt.Prepare(db,KUpdate));
<a name="l00348"></a>00348
<a name="l00349"></a>00349 <span class="comment">// Open the parameter stream</span>
<a name="l00350"></a>00350 RSqlParamWriteStream strm;
<a name="l00351"></a>00351 CleanupClosePushL(strm);
<a name="l00352"></a>00352
<a name="l00353"></a>00353 <span class="comment">// Prepare and set the parameter value (non-NULL value)</span>
<a name="l00354"></a>00354 User::LeaveIfError(strm.BindBinary(stmt, 0));
<a name="l00355"></a>00355
<a name="l00356"></a>00356 <span class="keywordflow">for</span>(TInt i=0;i<100;++i)
<a name="l00357"></a>00357 {
<a name="l00358"></a>00358 strm << static_cast <TUint8> (i);
<a name="l00359"></a>00359 }
<a name="l00360"></a>00360 <span class="comment">// Write the buffered data into stream</span>
<a name="l00361"></a>00361 strm.CommitL();
<a name="l00362"></a>00362 <span class="comment">// Execute the prepared SQL statement </span>
<a name="l00363"></a>00363 User::LeaveIfError(stmt.Exec());
<a name="l00364"></a>00364
<a name="l00365"></a>00365 CleanupStack::PopAndDestroy(&strm);
<a name="l00366"></a>00366 CleanupStack::PopAndDestroy(&stmt);
<a name="l00367"></a>00367
<a name="l00368"></a>00368 TSqlScalarFullSelectQuery fullSelectQuery(db);
<a name="l00369"></a>00369
<a name="l00370"></a>00370 TBuf<100> sql;
<a name="l00371"></a>00371
<a name="l00372"></a>00372 <span class="comment">// Query with F2 column (64-bit integer column)</span>
<a name="l00373"></a>00373 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KAnotherSql, <span class="stringliteral">"SELECT F2 FROM A WHERE F1 = 1"</span>);
<a name="l00374"></a>00374 sql.Copy(KAnotherSql);
<a name="l00375"></a>00375 <span class="comment">// Read F2 as integer.</span>
<a name="l00376"></a>00376 TInt valInt = fullSelectQuery.SelectIntL(sql);
<a name="l00377"></a>00377
<a name="l00378"></a>00378 <span class="comment">// Read F2 as 64-bit integer. Expected value: 10000000000</span>
<a name="l00379"></a>00379 TInt64 valInt64 = fullSelectQuery.SelectInt64L(sql);
<a name="l00380"></a>00380
<a name="l00381"></a>00381 <span class="comment">// Read F2 as real. Expected value: 10000000000.0</span>
<a name="l00382"></a>00382 TReal valReal = fullSelectQuery.SelectRealL(sql);
<a name="l00383"></a>00383
<a name="l00384"></a>00384 <span class="comment">// Read F2 as text. Expected value: zero-length 16-bit descriptor.</span>
<a name="l00385"></a>00385 TBuf<10> valText;
<a name="l00386"></a>00386 TInt err = fullSelectQuery.SelectTextL(sql, valText);
<a name="l00387"></a>00387
<a name="l00388"></a>00388 <span class="comment">// Read F2 as binary. Expected value: zero-length 8-bit descriptor.</span>
<a name="l00389"></a>00389 TBuf8<10> valBinary;
<a name="l00390"></a>00390 err = fullSelectQuery.SelectBinaryL(sql, valBinary);
<a name="l00391"></a>00391
<a name="l00392"></a>00392 <span class="comment">// Query with F4 column (text column) </span>
<a name="l00393"></a>00393 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSql4, <span class="stringliteral">"SELECT F4 FROM A WHERE F1 = 1"</span>);
<a name="l00394"></a>00394 sql.Copy(KSql4);
<a name="l00395"></a>00395 <span class="comment">// Read F4 as integer. Expected value: 0.</span>
<a name="l00396"></a>00396 valInt = fullSelectQuery.SelectIntL(sql);
<a name="l00397"></a>00397
<a name="l00398"></a>00398 <span class="comment">//Read F4 as 64-bit integer. Expected value: 0.</span>
<a name="l00399"></a>00399 valInt64 = fullSelectQuery.SelectInt64L(sql);
<a name="l00400"></a>00400
<a name="l00401"></a>00401 <span class="comment">// Read F4 as real. Expected value: 0.0.</span>
<a name="l00402"></a>00402 valReal = fullSelectQuery.SelectRealL(sql);
<a name="l00403"></a>00403
<a name="l00404"></a>00404 <span class="comment">// Read F4 as text. Small buffer. Expected return code: positive value, which is the column length in characters.</span>
<a name="l00405"></a>00405 err = fullSelectQuery.SelectTextL(sql, valText);
<a name="l00406"></a>00406
<a name="l00407"></a>00407 <span class="comment">// Read F4 as text. Big enough buffer. </span>
<a name="l00408"></a>00408 TBuf<32> valText2;
<a name="l00409"></a>00409 err = fullSelectQuery.SelectTextL(sql, valText2);
<a name="l00410"></a>00410
<a name="l00411"></a>00411 <span class="comment">// Read F4 as binary. Expected error: KErrNone. Zero-length 8-bit descriptor.</span>
<a name="l00412"></a>00412 err = fullSelectQuery.SelectBinaryL(sql, valBinary);
<a name="l00413"></a>00413
<a name="l00414"></a>00414 <span class="comment">// Read F5 as binary. Big enough buffer.</span>
<a name="l00415"></a>00415 TBuf8<100> valBinary2;
<a name="l00416"></a>00416 err = fullSelectQuery.SelectBinaryL(sql, valBinary2);
<a name="l00417"></a>00417
<a name="l00418"></a>00418 <span class="comment">// Text column value, small buffer, reallocation </span>
<a name="l00419"></a>00419 HBufC* hbuf = <a class="code" href="class_c_sql_example.html#a8b115210a3fbfa19de5c7f6a0abf3e43">HBufC::NewLC</a>(10);
<a name="l00420"></a>00420 TPtr name = hbuf->Des();
<a name="l00421"></a>00421 sql.Copy(KSql4);
<a name="l00422"></a>00422 err = fullSelectQuery.SelectTextL(sql, name);
<a name="l00423"></a>00423
<a name="l00424"></a>00424 <span class="keywordflow">if</span>(err > 0)
<a name="l00425"></a>00425 {
<a name="l00426"></a>00426 hbuf = hbuf->ReAllocL(err);
<a name="l00427"></a>00427 CleanupStack::Pop();
<a name="l00428"></a>00428 CleanupStack::PushL(hbuf);
<a name="l00429"></a>00429 name.Set(hbuf->Des());
<a name="l00430"></a>00430 err = fullSelectQuery.SelectTextL(sql, name);
<a name="l00431"></a>00431
<a name="l00432"></a>00432 }
<a name="l00433"></a>00433 CleanupStack::PopAndDestroy(); <span class="comment">// hbuf, can't be put as parameter, because may be reallocated</span>
<a name="l00434"></a>00434 <span class="comment">//Close database, delete database file.</span>
<a name="l00435"></a>00435 db.Close();
<a name="l00436"></a>00436 User::LeaveIfError(RSqlDatabase::Delete(KDatabase));
<a name="l00437"></a>00437
<a name="l00438"></a>00438 }
<a name="l00439"></a>00439
<a name="l00447"></a><a class="code" href="class_c_sql_example.html#a12e036a57115aceb1c64545fc9dee052">00447</a> <span class="keywordtype">void</span> <a class="code" href="class_c_sql_example.html#a12e036a57115aceb1c64545fc9dee052">CSqlExample::ColumnBinaryStreamL</a>()
<a name="l00448"></a>00448 {
<a name="l00449"></a>00449 RSqlDatabase db;
<a name="l00450"></a>00450 TInt error;
<a name="l00451"></a>00451 User::LeaveIfError(db.Create(KDbName));
<a name="l00452"></a>00452
<a name="l00453"></a>00453 <span class="comment">// Create a table</span>
<a name="l00454"></a>00454 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSqlStmt1, <span class="stringliteral">"CREATE TABLE A(Fld1 INTEGER, Fld2 BLOB);"</span>);
<a name="l00455"></a>00455
<a name="l00456"></a>00456 User::LeaveIfError(error = db.Exec(KSqlStmt1));
<a name="l00457"></a>00457 <span class="keyword">const</span> TInt KDataLen = 100;
<a name="l00458"></a>00458
<a name="l00459"></a>00459 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSqlStmt2, <span class="stringliteral">"INSERT INTO A(Fld1, Fld2) VALUES("</span>);
<a name="l00460"></a>00460
<a name="l00461"></a>00461 <span class="comment">// Allocate a buffer for the SQL statement.</span>
<a name="l00462"></a>00462 HBufC8* buf = HBufC8::New(KSqlStmt2().Length() + KDataLen * 2 + 10);
<a name="l00463"></a>00463
<a name="l00464"></a>00464 TPtr8 sql = buf->Des();
<a name="l00465"></a>00465
<a name="l00466"></a>00466 <span class="comment">// Insert row 1</span>
<a name="l00467"></a>00467
<a name="l00468"></a>00468 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KHexValStr1, <span class="stringliteral">"7E"</span>);
<a name="l00469"></a>00469 sql.Copy(KSqlStmt2);
<a name="l00470"></a>00470
<a name="l00471"></a>00471 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KString1, <span class="stringliteral">"1, x'"</span>);
<a name="l00472"></a>00472 sql.Append(KString1);
<a name="l00473"></a>00473 TInt i;
<a name="l00474"></a>00474 <span class="keywordflow">for</span>(i=0;i<KDataLen;++i)
<a name="l00475"></a>00475 {
<a name="l00476"></a>00476 sql.Append(KHexValStr1);
<a name="l00477"></a>00477 }
<a name="l00478"></a>00478 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KString2, <span class="stringliteral">"')"</span>);
<a name="l00479"></a>00479 sql.Append(KString2);
<a name="l00480"></a>00480
<a name="l00481"></a>00481 User::LeaveIfError(db.Exec(sql));
<a name="l00482"></a>00482
<a name="l00483"></a>00483 <span class="comment">// Insert row 2</span>
<a name="l00484"></a>00484
<a name="l00485"></a>00485 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KHexValStr2, <span class="stringliteral">"A3"</span>);
<a name="l00486"></a>00486 sql.Copy(KSqlStmt2);
<a name="l00487"></a>00487 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KString3, <span class="stringliteral">"2, x'"</span>);
<a name="l00488"></a>00488 sql.Append(KString3);
<a name="l00489"></a>00489 <span class="keywordflow">for</span>(i=0;i<KDataLen;++i)
<a name="l00490"></a>00490 {
<a name="l00491"></a>00491 sql.Append(KHexValStr2);
<a name="l00492"></a>00492 }
<a name="l00493"></a>00493 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KString4, <span class="stringliteral">"')"</span>);
<a name="l00494"></a>00494 sql.Append(KString4);
<a name="l00495"></a>00495
<a name="l00496"></a>00496 User::LeaveIfError(db.Exec(sql));
<a name="l00497"></a>00497
<a name="l00498"></a>00498 <span class="comment">// Prepare SELECT SQL statement</span>
<a name="l00499"></a>00499 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSqlStmt3, <span class="stringliteral">"SELECT * FROM A"</span>);
<a name="l00500"></a>00500
<a name="l00501"></a>00501 RSqlStatement stmt;
<a name="l00502"></a>00502 User::LeaveIfError(error = stmt.Prepare(db, KSqlStmt3));
<a name="l00503"></a>00503
<a name="l00504"></a>00504 <span class="comment">// Move on row 1</span>
<a name="l00505"></a>00505 User::LeaveIfError(error = stmt.Next());
<a name="l00506"></a>00506
<a name="l00507"></a>00507 <span class="comment">// Read the long binary column using a stream</span>
<a name="l00508"></a>00508 RSqlColumnReadStream columnStream;
<a name="l00509"></a>00509 error = columnStream.ColumnBinary(stmt, 1);
<a name="l00510"></a>00510
<a name="l00511"></a>00511
<a name="l00512"></a>00512 TInt size = stmt.ColumnSize(1);
<a name="l00513"></a>00513 TPtr8 colData = buf->Des();
<a name="l00514"></a>00514 TRAP(error, columnStream.ReadL(colData, size));
<a name="l00515"></a>00515 columnStream.Close();
<a name="l00516"></a>00516
<a name="l00517"></a>00517 User::LeaveIfError(stmt.Next());
<a name="l00518"></a>00518
<a name="l00519"></a>00519 <span class="comment">//Read row 2 using ColumnBinary(TInt aColumnIndex, TDes8& aDest).</span>
<a name="l00520"></a>00520 error = stmt.ColumnBinary(1, colData);
<a name="l00521"></a>00521
<a name="l00522"></a>00522 <span class="comment">//Read row 2 using a stream</span>
<a name="l00523"></a>00523 colData.Zero();
<a name="l00524"></a>00524 error = columnStream.ColumnBinary(stmt, 1);
<a name="l00525"></a>00525
<a name="l00526"></a>00526 size = stmt.ColumnSize(1);
<a name="l00527"></a>00527 TRAP(error, columnStream.ReadL(colData, size));
<a name="l00528"></a>00528 columnStream.Close();
<a name="l00529"></a>00529
<a name="l00530"></a>00530 stmt.Close();
<a name="l00531"></a>00531
<a name="l00532"></a>00532 <span class="keyword">delete</span> buf;
<a name="l00533"></a>00533 buf = NULL;
<a name="l00534"></a>00534
<a name="l00535"></a>00535 db.Close();
<a name="l00536"></a>00536
<a name="l00537"></a>00537 error = RSqlDatabase::Delete(KDbName);
<a name="l00538"></a>00538
<a name="l00539"></a>00539 }
<a name="l00540"></a>00540
<a name="l00541"></a>00541
<a name="l00542"></a><a class="code" href="sqlexample_8cpp.html#a689e0bf9aa924a1d7dc108665d44736c">00542</a> LOCAL_C <span class="keywordtype">void</span> MainL()
<a name="l00543"></a>00543 {
<a name="l00544"></a>00544 <span class="comment">// Create an Active Scheduler to handle asychronous calls</span>
<a name="l00545"></a>00545 CActiveScheduler* scheduler = <span class="keyword">new</span> (ELeave) CActiveScheduler;
<a name="l00546"></a>00546 CleanupStack::PushL(scheduler);
<a name="l00547"></a>00547 CActiveScheduler::Install( scheduler );
<a name="l00548"></a>00548 <a class="code" href="class_c_sql_example.html">CSqlExample</a>* app = <a class="code" href="class_c_sql_example.html#a8b115210a3fbfa19de5c7f6a0abf3e43">CSqlExample::NewLC</a>();
<a name="l00549"></a>00549
<a name="l00550"></a>00550 <span class="comment">// Create a non secure database</span>
<a name="l00551"></a>00551 app-><a class="code" href="class_c_sql_example.html#af0523fb9c7a711a2c7745e8d2e96faa7">CreateNonSecureDBL</a>();
<a name="l00552"></a>00552
<a name="l00553"></a>00553 <span class="comment">// Create and open a secure database</span>
<a name="l00554"></a>00554 app-><a class="code" href="class_c_sql_example.html#a2d2358e96bba71900cedd067fe44192b">CreateAndOpenSecureDBL</a>();
<a name="l00555"></a>00555
<a name="l00556"></a>00556 <span class="comment">// Copy two databases</span>
<a name="l00557"></a>00557 app-><a class="code" href="class_c_sql_example.html#a1a6247133748297a2a8877381583e51c">CopyDatabaseL</a>();
<a name="l00558"></a>00558
<a name="l00559"></a>00559 <span class="comment">// Attach two databases</span>
<a name="l00560"></a>00560 app-><a class="code" href="class_c_sql_example.html#adf02168d537e9e1650d5f379522a6b2e">AttachDatabasesL</a>();
<a name="l00561"></a>00561
<a name="l00562"></a>00562 <span class="comment">// Simple query and query with paramaters</span>
<a name="l00563"></a>00563 app-><a class="code" href="class_c_sql_example.html#a49067abc75f826bfd43be44c07460c7b">DataTypesQueryL</a>();
<a name="l00564"></a>00564
<a name="l00565"></a>00565 <span class="comment">//Prepares and executes a query with a large parameter</span>
<a name="l00566"></a>00566 <span class="comment">// writing that parameter using streaming (RParamWriteStream)</span>
<a name="l00567"></a>00567 app-><a class="code" href="class_c_sql_example.html#a7fac459ccd95278c1af4eb50e5453812">ScalarFullSelectL</a>();
<a name="l00568"></a>00568
<a name="l00569"></a>00569 <span class="comment">// Prepare and execute a query which returns data,</span>
<a name="l00570"></a>00570 <span class="comment">// and read that data using streaming (RColumnReadStream)</span>
<a name="l00571"></a>00571 app-><a class="code" href="class_c_sql_example.html#a12e036a57115aceb1c64545fc9dee052">ColumnBinaryStreamL</a>();
<a name="l00572"></a>00572
<a name="l00573"></a>00573 CleanupStack::PopAndDestroy(2); <span class="comment">//app, scheduler</span>
<a name="l00574"></a>00574
<a name="l00575"></a>00575 }
<a name="l00576"></a>00576
<a name="l00577"></a><a class="code" href="sqlexample_8cpp.html#a0f358e9c4355138f629b8c4f37310295">00577</a> GLDEF_C TInt E32Main()
<a name="l00578"></a>00578 {
<a name="l00579"></a>00579 __UHEAP_MARK;
<a name="l00580"></a>00580 CTrapCleanup* cleanup = CTrapCleanup::New();
<a name="l00581"></a>00581 <span class="keywordflow">if</span>(cleanup == NULL)
<a name="l00582"></a>00582 {
<a name="l00583"></a>00583 <span class="keywordflow">return</span> KErrNoMemory;
<a name="l00584"></a>00584 }
<a name="l00585"></a>00585 TRAPD(err, MainL());
<a name="l00586"></a>00586 <span class="keywordflow">if</span>(err != KErrNone)
<a name="l00587"></a>00587 {
<a name="l00588"></a>00588 User::Panic(_L(<span class="stringliteral">"Failed to complete"</span>),err);
<a name="l00589"></a>00589 }
<a name="l00590"></a>00590
<a name="l00591"></a>00591 <span class="keyword">delete</span> cleanup;
<a name="l00592"></a>00592 __UHEAP_MARKEND;
<a name="l00593"></a>00593 <span class="keywordflow">return</span> KErrNone;
<a name="l00594"></a>00594 }
</pre></div></div>
<hr size="1"/><address style="text-align: right;"><small>Generated by
<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.6.2 </small></address>
</body>
</html>