Mercurial Mercurial > oss > MCL > sftools > depl > docscontent / annotate
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Symbian3/Examples/guid-6013a680-57f9-415b-8851-c4fa63356636/sqlexample_8cpp_source.html
author Dominic Pinkman <dominic.pinkman@nokia.com>
Fri, 13 Aug 2010 16:47:46 +0100
changeset 14 578be2adaf3e
parent 6 43e37759235e
permissions -rw-r--r--
Week 32 contribution of PDK documentation content. See release notes for details. Fixes bug Bug 3582
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
6
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
     1
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
     2
 
<html xmlns="http://www.w3.org/1999/xhtml">
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
     3
 
<head>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
     4
 
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
     5
 
<title>TB9.2 Example Applications: examples/SysLibs/SqlExample/sqlexample.cpp Source File</title>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
     6
 
<link href="tabs.css" rel="stylesheet" type="text/css"/>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
     7
 
<link href="doxygen.css" rel="stylesheet" type="text/css"/>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
     8
 
</head>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
     9
 
<body>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    10
 
<!-- Generated by Doxygen 1.6.2 -->
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    11
 
<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>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    12
 
<a name="l00002"></a>00002 <span class="comment">// All rights reserved.</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    13
 
<a name="l00003"></a>00003 <span class="comment">// This component and the accompanying materials are made available</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    14
 
<a name="l00004"></a>00004 <span class="comment">// under the terms of &quot;Eclipse Public License v1.0&quot;</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    15
 
<a name="l00005"></a>00005 <span class="comment">// which accompanies this distribution, and is available</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    16
 
<a name="l00006"></a>00006 <span class="comment">// at the URL &quot;http://www.eclipse.org/legal/epl-v10.html&quot;.</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    17
 
<a name="l00007"></a>00007 <span class="comment">//</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    18
 
<a name="l00008"></a>00008 <span class="comment">// Initial Contributors:</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    19
 
<a name="l00009"></a>00009 <span class="comment">// Nokia Corporation - initial contribution.</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    20
 
<a name="l00010"></a>00010 <span class="comment">//</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    21
 
<a name="l00011"></a>00011 <span class="comment">// Contributors:</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    22
 
<a name="l00012"></a>00012 <span class="comment">//</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    23
 
<a name="l00013"></a>00013 <span class="comment">// Description:</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    24
 
<a name="l00014"></a>00014 <span class="comment">// This example program demonstrates the use of SQL APIs. </span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    25
 
<a name="l00015"></a>00015 <span class="comment">// The code demonstrates how to create non secure and secure databases on </span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    26
 
<a name="l00016"></a>00016 <span class="comment">// the writable drive and perform basic operations on the databases.</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    27
 
<a name="l00017"></a>00017 <span class="comment">//</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    28
 
<a name="l00018"></a>00018
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    29
 
<a name="l00019"></a>00019
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    30
 
<a name="l00020"></a>00020
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    31
 
<a name="l00024"></a>00024 <span class="preprocessor">#include &quot;<a class="code" href="sqlexample_8h.html">sqlexample.h</a>&quot;</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    32
 
<a name="l00025"></a>00025 <span class="preprocessor">#include &lt;e32cons.h&gt;</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    33
 
<a name="l00026"></a>00026 <span class="preprocessor">#include &lt;sqldb.h&gt;</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    34
 
<a name="l00027"></a>00027
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    35
 
<a name="l00028"></a>00028 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KTitle, <span class="stringliteral">&quot;SQL example&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    36
 
<a name="l00029"></a>00029 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KTextPressAKey, <span class="stringliteral">&quot;\n\nPress any key to step through the example\n&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    37
 
<a name="l00030"></a>00030 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KExit,<span class="stringliteral">&quot;Press any key to exit the application &quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    38
 
<a name="l00031"></a>00031 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KPressAKey,<span class="stringliteral">&quot;Press any key to continue \n&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    39
 
<a name="l00032"></a>00032 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KNonSecure,<span class="stringliteral">&quot;\nCreating a non secure database \n&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    40
 
<a name="l00033"></a>00033 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSecure,<span class="stringliteral">&quot;\nCreating a secure database \n&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    41
 
<a name="l00034"></a>00034 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KOpen,<span class="stringliteral">&quot;Opening  the secure database \n&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    42
 
<a name="l00035"></a>00035 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KDelete,<span class="stringliteral">&quot;Deleting the database(s)\n&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    43
 
<a name="l00036"></a>00036 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KClose,<span class="stringliteral">&quot;Closing the database(s)\n&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    44
 
<a name="l00037"></a>00037 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KCopyNonSec,<span class="stringliteral">&quot;\nCopying a non secure database to another non secure one \n&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    45
 
<a name="l00038"></a>00038 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KCopySecure,<span class="stringliteral">&quot;\nCopying a secure database to another secure database \n&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    46
 
<a name="l00039"></a>00039 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KAttach,<span class="stringliteral">&quot;\nOpen a secure database and attach another secure database\n&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    47
 
<a name="l00040"></a>00040 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KCreateTable,<span class="stringliteral">&quot;\nCreating a table\n&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    48
 
<a name="l00041"></a>00041 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KInsert,<span class="stringliteral">&quot;Inserting records into the table\n&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    49
 
<a name="l00042"></a>00042 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KPrepare,<span class="stringliteral">&quot;Preparing a query\n&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    50
 
<a name="l00043"></a>00043 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KExecute,<span class="stringliteral">&quot;Executing a query\n&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    51
 
<a name="l00044"></a>00044
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    52
 
<a name="l00045"></a>00045 <span class="comment">// Names of the databases created, operated upon and later deleted.</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    53
 
<a name="l00046"></a>00046 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KDbName, <span class="stringliteral">&quot;\\Example_db.db&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    54
 
<a name="l00047"></a>00047 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KAnotherDbName, <span class="stringliteral">&quot;\\Example_Anotherdb.db&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    55
 
<a name="l00048"></a>00048 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSecureDb1, <span class="stringliteral">&quot;[E80000AF]db1.db&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    56
 
<a name="l00049"></a>00049 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSecureDb2, <span class="stringliteral">&quot;[E80000AF]db2.db&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    57
 
<a name="l00050"></a>00050 <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KDatabase, <span class="stringliteral">&quot;\\Sqlscalarfullselect.db&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    58
 
<a name="l00051"></a>00051
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    59
 
<a name="l00052"></a>00052 <span class="comment">// Security policies used</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    60
 
<a name="l00053"></a>00053 <span class="keyword">const</span> TSecurityPolicy KPolicy1(ECapabilityReadUserData, ECapabilityNetworkControl,  ECapabilityWriteUserData);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    61
 
<a name="l00054"></a>00054 <span class="keyword">const</span> TSecurityPolicy KPolicy2(ECapabilityReadUserData);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    62
 
<a name="l00055"></a>00055
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    63
 
<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>()
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    64
 
<a name="l00062"></a>00062         {
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    65
 
<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>();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    66
 
<a name="l00064"></a>00064         CleanupStack::PushL(rep);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    67
 
<a name="l00065"></a>00065         rep-&gt;ConstructL();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    68
 
<a name="l00066"></a>00066         <span class="keywordflow">return</span> rep;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    69
 
<a name="l00067"></a>00067         }
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    70
 
<a name="l00068"></a>00068
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    71
 
<a name="l00072"></a>00072 CSqlExample::CSqlExample()
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    72
 
<a name="l00073"></a>00073         {
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    73
 
<a name="l00074"></a>00074         }
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    74
 
<a name="l00075"></a>00075
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    75
 
<a name="l00076"></a>00076 <span class="keywordtype">void</span> CSqlExample::ConstructL()
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    76
 
<a name="l00077"></a>00077         {
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    77
 
<a name="l00078"></a>00078         iConsole = Console::NewL(KTitle,TSize(KConsFullScreen,KConsFullScreen));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    78
 
<a name="l00079"></a>00079         iConsole-&gt;Printf ( KTextPressAKey );
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    79
 
<a name="l00080"></a>00080         iConsole-&gt;Getch ();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    80
 
<a name="l00081"></a>00081         }
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    81
 
<a name="l00082"></a>00082
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    82
 
<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>()
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    83
 
<a name="l00087"></a>00087         {
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    84
 
<a name="l00088"></a>00088         iConsole-&gt;Printf(KExit);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    85
 
<a name="l00089"></a>00089         iConsole-&gt;Getch();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    86
 
<a name="l00090"></a>00090
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    87
 
<a name="l00091"></a>00091         <span class="keyword">delete</span> iConsole;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    88
 
<a name="l00092"></a>00092         }
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    89
 
<a name="l00093"></a>00093
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    90
 
<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>()
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    91
 
<a name="l00101"></a>00101         {
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    92
 
<a name="l00102"></a>00102         TBuf&lt;200&gt; buffer;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    93
 
<a name="l00103"></a>00103         RSqlDatabase db;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    94
 
<a name="l00104"></a>00104
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    95
 
<a name="l00105"></a>00105         <span class="comment">// Create non-secure database</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    96
 
<a name="l00106"></a>00106         iConsole-&gt;Printf(KNonSecure);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    97
 
<a name="l00107"></a>00107         TInt error;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    98
 
<a name="l00108"></a>00108         TRAP(error,db.Create(KDbName););
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
    99
 
<a name="l00109"></a>00109
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   100
 
<a name="l00110"></a>00110         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KTable,<span class="stringliteral">&quot;CREATE TABLE A1(F1 INTEGER, F2 INTEGER)&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   101
 
<a name="l00111"></a>00111         User::LeaveIfError(error = db.Exec(KTable));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   102
 
<a name="l00112"></a>00112
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   103
 
<a name="l00113"></a>00113         db.Close();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   104
 
<a name="l00114"></a>00114         iConsole-&gt;Printf(KClose);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   105
 
<a name="l00115"></a>00115         iConsole-&gt;Printf(KPressAKey);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   106
 
<a name="l00116"></a>00116         iConsole-&gt;Getch();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   107
 
<a name="l00117"></a>00117         }
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   108
 
<a name="l00118"></a>00118
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   109
 
<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>()
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   110
 
<a name="l00128"></a>00128         {
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   111
 
<a name="l00129"></a>00129         RSqlDatabase db;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   112
 
<a name="l00130"></a>00130         RSqlSecurityPolicy securityPolicy;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   113
 
<a name="l00131"></a>00131
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   114
 
<a name="l00132"></a>00132         User::LeaveIfError(securityPolicy.Create(TSecurityPolicy(TSecurityPolicy::EAlwaysPass)));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   115
 
<a name="l00133"></a>00133         User::LeaveIfError(securityPolicy.SetDbPolicy(RSqlSecurityPolicy::EWritePolicy, KPolicy1));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   116
 
<a name="l00134"></a>00134
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   117
 
<a name="l00135"></a>00135         iConsole-&gt;Printf(KSecure);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   118
 
<a name="l00136"></a>00136         User::LeaveIfError(db.Create(KSecureDb1, securityPolicy));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   119
 
<a name="l00137"></a>00137
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   120
 
<a name="l00138"></a>00138         securityPolicy.Close();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   121
 
<a name="l00139"></a>00139
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   122
 
<a name="l00140"></a>00140         <span class="comment">// Check that the database security policy matches the policy used </span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   123
 
<a name="l00141"></a>00141         <span class="comment">//when the database was created.</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   124
 
<a name="l00142"></a>00142         User::LeaveIfError(db.GetSecurityPolicy(securityPolicy));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   125
 
<a name="l00143"></a>00143
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   126
 
<a name="l00144"></a>00144         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSecureCreate,<span class="stringliteral">&quot;CREATE TABLE secure(int_fld integer, null_int_fld integer default null)&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   127
 
<a name="l00145"></a>00145         User::LeaveIfError(db.Exec(KSecureCreate));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   128
 
<a name="l00146"></a>00146
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   129
 
<a name="l00147"></a>00147         <span class="comment">// Attempt to write to the secure database</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   130
 
<a name="l00148"></a>00148         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSecureInsert,<span class="stringliteral">&quot;INSERT INTO secure(int_fld) values(200)&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   131
 
<a name="l00149"></a>00149         User::LeaveIfError(db.Exec(KSecureInsert));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   132
 
<a name="l00150"></a>00150         db.Close();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   133
 
<a name="l00151"></a>00151
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   134
 
<a name="l00152"></a>00152         iConsole-&gt;Printf(KOpen);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   135
 
<a name="l00153"></a>00153         <span class="comment">// Open the secure database     </span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   136
 
<a name="l00154"></a>00154         User::LeaveIfError(db.Open(KSecureDb1));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   137
 
<a name="l00155"></a>00155
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   138
 
<a name="l00156"></a>00156         db.Close();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   139
 
<a name="l00157"></a>00157         iConsole-&gt;Printf(KClose);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   140
 
<a name="l00158"></a>00158         iConsole-&gt;Printf(KPressAKey);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   141
 
<a name="l00159"></a>00159         iConsole-&gt;Getch();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   142
 
<a name="l00160"></a>00160         securityPolicy.Close();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   143
 
<a name="l00161"></a>00161
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   144
 
<a name="l00162"></a>00162         }
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   145
 
<a name="l00163"></a>00163
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   146
 
<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>()
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   147
 
<a name="l00172"></a>00172         {
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   148
 
<a name="l00173"></a>00173         RSqlDatabase db;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   149
 
<a name="l00174"></a>00174
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   150
 
<a name="l00175"></a>00175         <span class="comment">// Copy non-secure to non-secure database</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   151
 
<a name="l00176"></a>00176         iConsole-&gt;Printf(KCopyNonSec);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   152
 
<a name="l00177"></a>00177         User::LeaveIfError(RSqlDatabase::Copy(KDbName, KAnotherDbName));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   153
 
<a name="l00178"></a>00178
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   154
 
<a name="l00179"></a>00179         <span class="comment">// Delete the source database</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   155
 
<a name="l00180"></a>00180         iConsole-&gt;Printf(KDelete);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   156
 
<a name="l00181"></a>00181         User::LeaveIfError(RSqlDatabase::Delete(KAnotherDbName));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   157
 
<a name="l00182"></a>00182
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   158
 
<a name="l00183"></a>00183         <span class="comment">// Create another secure database with a different security policy,</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   159
 
<a name="l00184"></a>00184         <span class="comment">// KSecureDb1 is already created with KPolicy1.</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   160
 
<a name="l00185"></a>00185         RSqlSecurityPolicy securityPolicy;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   161
 
<a name="l00186"></a>00186         User::LeaveIfError(securityPolicy.Create(TSecurityPolicy(TSecurityPolicy::EAlwaysPass)));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   162
 
<a name="l00187"></a>00187
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   163
 
<a name="l00188"></a>00188         User::LeaveIfError(securityPolicy.SetDbPolicy(RSqlSecurityPolicy::EWritePolicy, KPolicy2));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   164
 
<a name="l00189"></a>00189
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   165
 
<a name="l00190"></a>00190         User::LeaveIfError(db.Create(KSecureDb2, securityPolicy));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   166
 
<a name="l00191"></a>00191
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   167
 
<a name="l00192"></a>00192         User::LeaveIfError(db.GetSecurityPolicy(securityPolicy));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   168
 
<a name="l00193"></a>00193         db.Close();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   169
 
<a name="l00194"></a>00194
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   170
 
<a name="l00195"></a>00195         <span class="comment">// Copy secure to secure database. The application is the database owner.</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   171
 
<a name="l00196"></a>00196         iConsole-&gt;Printf(KCopySecure);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   172
 
<a name="l00197"></a>00197         User::LeaveIfError(RSqlDatabase::Copy(KSecureDb1, KSecureDb2));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   173
 
<a name="l00198"></a>00198
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   174
 
<a name="l00199"></a>00199         <span class="comment">// Delete the source database</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   175
 
<a name="l00200"></a>00200         iConsole-&gt;Printf(KDelete);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   176
 
<a name="l00201"></a>00201         User::LeaveIfError(RSqlDatabase::Delete(KSecureDb1));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   177
 
<a name="l00202"></a>00202
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   178
 
<a name="l00203"></a>00203         iConsole-&gt;Printf(KPressAKey);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   179
 
<a name="l00204"></a>00204         iConsole-&gt;Getch();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   180
 
<a name="l00205"></a>00205         securityPolicy.Close();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   181
 
<a name="l00206"></a>00206         db.Close();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   182
 
<a name="l00207"></a>00207
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   183
 
<a name="l00208"></a>00208         }
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   184
 
<a name="l00209"></a>00209
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   185
 
<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>()
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   186
 
<a name="l00218"></a>00218         {
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   187
 
<a name="l00219"></a>00219         RSqlDatabase db;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   188
 
<a name="l00220"></a>00220         RSqlSecurityPolicy securityPolicy;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   189
 
<a name="l00221"></a>00221
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   190
 
<a name="l00222"></a>00222         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KAttachDb2, <span class="stringliteral">&quot;Db2&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   191
 
<a name="l00223"></a>00223
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   192
 
<a name="l00224"></a>00224         User::LeaveIfError(db.Open(KSecureDb2));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   193
 
<a name="l00225"></a>00225         iConsole-&gt;Printf(KAttach);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   194
 
<a name="l00226"></a>00226
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   195
 
<a name="l00227"></a>00227         User::LeaveIfError(db.Attach(KDbName, KAttachDb2));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   196
 
<a name="l00228"></a>00228
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   197
 
<a name="l00229"></a>00229         <span class="comment">// Attempt to write to the attached non secure database</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   198
 
<a name="l00230"></a>00230         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KTabInsert,<span class="stringliteral">&quot;INSERT INTO db2.a1(f1) valUES(10)&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   199
 
<a name="l00231"></a>00231         User::LeaveIfError(db.Exec(KTabInsert));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   200
 
<a name="l00232"></a>00232
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   201
 
<a name="l00233"></a>00233         <span class="comment">// Attempt to read from the attached non secure database</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   202
 
<a name="l00234"></a>00234         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSelect,<span class="stringliteral">&quot;SELECT * FROM db2.a1&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   203
 
<a name="l00235"></a>00235         User::LeaveIfError(db.Exec(KSelect));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   204
 
<a name="l00236"></a>00236
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   205
 
<a name="l00237"></a>00237         <span class="comment">// Attempt to write to the main secure database</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   206
 
<a name="l00238"></a>00238         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KAttachInsert,<span class="stringliteral">&quot;INSERT INTO a1(f1) valUES(10)&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   207
 
<a name="l00239"></a>00239         User::LeaveIfError(db.Exec(KAttachInsert));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   208
 
<a name="l00240"></a>00240
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   209
 
<a name="l00241"></a>00241         db.Close();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   210
 
<a name="l00242"></a>00242         iConsole-&gt;Printf(KDelete);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   211
 
<a name="l00243"></a>00243         User::LeaveIfError(RSqlDatabase::Delete(KDbName));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   212
 
<a name="l00244"></a>00244
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   213
 
<a name="l00245"></a>00245         User::LeaveIfError(RSqlDatabase::Delete(KSecureDb2));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   214
 
<a name="l00246"></a>00246
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   215
 
<a name="l00247"></a>00247         securityPolicy.Close();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   216
 
<a name="l00248"></a>00248
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   217
 
<a name="l00249"></a>00249         }
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   218
 
<a name="l00250"></a>00250
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   219
 
<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>()
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   220
 
<a name="l00258"></a>00258         {
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   221
 
<a name="l00259"></a>00259         RSqlDatabase db;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   222
 
<a name="l00260"></a>00260         iConsole-&gt;Printf(KSecure);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   223
 
<a name="l00261"></a>00261
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   224
 
<a name="l00262"></a>00262         User::LeaveIfError(db.Create(KDbName));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   225
 
<a name="l00263"></a>00263
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   226
 
<a name="l00264"></a>00264         <span class="comment">// Create a table with different numeric field types</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   227
 
<a name="l00265"></a>00265         iConsole-&gt;Printf(KCreateTable);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   228
 
<a name="l00266"></a>00266         iConsole-&gt;Printf(KExecute);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   229
 
<a name="l00267"></a>00267
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   230
 
<a name="l00268"></a>00268         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSql1, <span class="stringliteral">&quot;CREATE TABLE Tbl(A INTEGER, B SMALLINT, C REAL, D DOUBLE PRECISION, E FLOAT, \</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   231
 
<a name="l00269"></a>00269 <span class="stringliteral">                                                            F DECIMAL)&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   232
 
<a name="l00270"></a>00270         User::LeaveIfError(db.Exec(KSql1));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   233
 
<a name="l00271"></a>00271
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   234
 
<a name="l00272"></a>00272         <span class="comment">// Insert one record in to the created table</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   235
 
<a name="l00273"></a>00273         iConsole-&gt;Printf(KInsert);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   236
 
<a name="l00274"></a>00274         iConsole-&gt;Printf(KExecute);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   237
 
<a name="l00275"></a>00275
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   238
 
<a name="l00276"></a>00276         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSql2, <span class="stringliteral">&quot;INSERT INTO Tbl(A,B,C,D,E,F) VALUES(2000000000, 30000, 123.45, 0.912E+55,\</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   239
 
<a name="l00277"></a>00277 <span class="stringliteral">                                            1.34E-14, 1234.5678)&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   240
 
<a name="l00278"></a>00278         User::LeaveIfError(db.Exec(KSql2));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   241
 
<a name="l00279"></a>00279
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   242
 
<a name="l00280"></a>00280         <span class="comment">// Get the inserted record data</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   243
 
<a name="l00281"></a>00281         RSqlStatement stmt;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   244
 
<a name="l00282"></a>00282         iConsole-&gt;Printf(KPrepare);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   245
 
<a name="l00283"></a>00283
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   246
 
<a name="l00284"></a>00284         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KPrepQuery,<span class="stringliteral">&quot;SELECT * FROM Tbl&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   247
 
<a name="l00285"></a>00285         User::LeaveIfError(stmt.Prepare(db, KPrepQuery));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   248
 
<a name="l00286"></a>00286
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   249
 
<a name="l00287"></a>00287         User::LeaveIfError(stmt.Next());
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   250
 
<a name="l00288"></a>00288         stmt.Close();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   251
 
<a name="l00289"></a>00289
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   252
 
<a name="l00290"></a>00290         <span class="comment">// The statement object has to be closed before db.Exec() call, </span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   253
 
<a name="l00291"></a>00291         <span class="comment">// otherwise the reported error is &quot;database table is locked&quot;</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   254
 
<a name="l00292"></a>00292         <span class="comment">// Insert second record in to the created table but inverse the column types.</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   255
 
<a name="l00293"></a>00293         iConsole-&gt;Printf(KExecute);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   256
 
<a name="l00294"></a>00294         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSql3, <span class="stringliteral">&quot;INSERT INTO Tbl(A,   B,  C, D, E, F) VALUES(\</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   257
 
<a name="l00295"></a>00295 <span class="stringliteral">                                                                                -2.5,1.1,12,23,45,111)&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   258
 
<a name="l00296"></a>00296         User::LeaveIfError(db.Exec(KSql3));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   259
 
<a name="l00297"></a>00297
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   260
 
<a name="l00298"></a>00298         <span class="comment">// Get the inserted record data</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   261
 
<a name="l00299"></a>00299         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KPrepQuery2,<span class="stringliteral">&quot;SELECT * FROM Tbl&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   262
 
<a name="l00300"></a>00300         User::LeaveIfError(stmt.Prepare(db, KPrepQuery2));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   263
 
<a name="l00301"></a>00301
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   264
 
<a name="l00302"></a>00302         User::LeaveIfError(stmt.Next());
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   265
 
<a name="l00303"></a>00303
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   266
 
<a name="l00304"></a>00304         stmt.Close();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   267
 
<a name="l00305"></a>00305
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   268
 
<a name="l00306"></a>00306         <span class="comment">// Insert third record in to the created table</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   269
 
<a name="l00307"></a>00307         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSql4, <span class="stringliteral">&quot;INSERT INTO Tbl(A,B,C,D,E,F) VALUES(\</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   270
 
<a name="l00308"></a>00308 <span class="stringliteral">                                            2,3,123.45,1.5,2.5,1.56)&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   271
 
<a name="l00309"></a>00309         User::LeaveIfError(db.Exec(KSql4));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   272
 
<a name="l00310"></a>00310
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   273
 
<a name="l00311"></a>00311         stmt.Close();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   274
 
<a name="l00312"></a>00312         db.Close();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   275
 
<a name="l00313"></a>00313         User::LeaveIfError(RSqlDatabase::Delete(KDbName));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   276
 
<a name="l00314"></a>00314         }
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   277
 
<a name="l00315"></a>00315
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   278
 
<a name="l00316"></a>00316
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   279
 
<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>()
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   280
 
<a name="l00329"></a>00329         {
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   281
 
<a name="l00330"></a>00330         RSqlDatabase db;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   282
 
<a name="l00331"></a>00331         <span class="comment">//Create  database.</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   283
 
<a name="l00332"></a>00332         User::LeaveIfError(db.Create(KDatabase));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   284
 
<a name="l00333"></a>00333
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   285
 
<a name="l00334"></a>00334         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KTabCreateA,<span class="stringliteral">&quot;CREATE TABLE A(F1 INTEGER, F2 INTEGER, F3 FLOAT, F4 TEXT, F5 BLOB)&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   286
 
<a name="l00335"></a>00335         User::LeaveIfError(db.Exec(KTabCreateA));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   287
 
<a name="l00336"></a>00336
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   288
 
<a name="l00337"></a>00337         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KTabInsert1A,<span class="stringliteral">&quot;INSERT INTO A(F1, F2, F3, F4, F5) VALUES(1, 10000000000, 2.54, &#39;NAME1234567890&#39;, NULL)&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   289
 
<a name="l00338"></a>00338         User::LeaveIfError(db.Exec(KTabInsert1A));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   290
 
<a name="l00339"></a>00339
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   291
 
<a name="l00340"></a>00340         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KTabInsert2A,<span class="stringliteral">&quot;INSERT INTO A(F1, F2, F3, F4) VALUES(2, 200, -1.11, &#39;ADDRESS&#39;)&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   292
 
<a name="l00341"></a>00341         User::LeaveIfError(db.Exec(KTabInsert2A));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   293
 
<a name="l00342"></a>00342
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   294
 
<a name="l00343"></a>00343         RSqlStatement stmt;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   295
 
<a name="l00344"></a>00344         CleanupClosePushL(stmt);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   296
 
<a name="l00345"></a>00345
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   297
 
<a name="l00346"></a>00346         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KUpdate,<span class="stringliteral">&quot;UPDATE A SET F5=:P WHERE F1 = 2&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   298
 
<a name="l00347"></a>00347         User::LeaveIfError(stmt.Prepare(db,KUpdate));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   299
 
<a name="l00348"></a>00348
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   300
 
<a name="l00349"></a>00349         <span class="comment">// Open the parameter stream</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   301
 
<a name="l00350"></a>00350         RSqlParamWriteStream strm;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   302
 
<a name="l00351"></a>00351         CleanupClosePushL(strm);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   303
 
<a name="l00352"></a>00352
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   304
 
<a name="l00353"></a>00353         <span class="comment">// Prepare and set the parameter value (non-NULL value)</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   305
 
<a name="l00354"></a>00354         User::LeaveIfError(strm.BindBinary(stmt, 0));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   306
 
<a name="l00355"></a>00355
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   307
 
<a name="l00356"></a>00356         <span class="keywordflow">for</span>(TInt i=0;i&lt;100;++i)
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   308
 
<a name="l00357"></a>00357                 {
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   309
 
<a name="l00358"></a>00358                 strm &lt;&lt; static_cast &lt;TUint8&gt; (i);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   310
 
<a name="l00359"></a>00359                 }
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   311
 
<a name="l00360"></a>00360         <span class="comment">// Write the buffered data into stream</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   312
 
<a name="l00361"></a>00361         strm.CommitL();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   313
 
<a name="l00362"></a>00362         <span class="comment">// Execute the prepared SQL statement   </span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   314
 
<a name="l00363"></a>00363         User::LeaveIfError(stmt.Exec());
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   315
 
<a name="l00364"></a>00364
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   316
 
<a name="l00365"></a>00365         CleanupStack::PopAndDestroy(&amp;strm);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   317
 
<a name="l00366"></a>00366         CleanupStack::PopAndDestroy(&amp;stmt);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   318
 
<a name="l00367"></a>00367
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   319
 
<a name="l00368"></a>00368         TSqlScalarFullSelectQuery fullSelectQuery(db);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   320
 
<a name="l00369"></a>00369
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   321
 
<a name="l00370"></a>00370         TBuf&lt;100&gt; sql;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   322
 
<a name="l00371"></a>00371
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   323
 
<a name="l00372"></a>00372         <span class="comment">// Query with F2 column (64-bit integer column)</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   324
 
<a name="l00373"></a>00373         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KAnotherSql, <span class="stringliteral">&quot;SELECT F2 FROM A WHERE F1 = 1&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   325
 
<a name="l00374"></a>00374         sql.Copy(KAnotherSql);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   326
 
<a name="l00375"></a>00375         <span class="comment">// Read F2 as integer.</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   327
 
<a name="l00376"></a>00376         TInt valInt = fullSelectQuery.SelectIntL(sql);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   328
 
<a name="l00377"></a>00377
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   329
 
<a name="l00378"></a>00378         <span class="comment">// Read F2 as 64-bit integer. Expected value: 10000000000</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   330
 
<a name="l00379"></a>00379         TInt64  valInt64 = fullSelectQuery.SelectInt64L(sql);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   331
 
<a name="l00380"></a>00380
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   332
 
<a name="l00381"></a>00381         <span class="comment">// Read F2 as real. Expected value: 10000000000.0</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   333
 
<a name="l00382"></a>00382         TReal valReal = fullSelectQuery.SelectRealL(sql);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   334
 
<a name="l00383"></a>00383
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   335
 
<a name="l00384"></a>00384         <span class="comment">// Read F2 as text. Expected value: zero-length 16-bit descriptor.</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   336
 
<a name="l00385"></a>00385         TBuf&lt;10&gt; valText;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   337
 
<a name="l00386"></a>00386         TInt err = fullSelectQuery.SelectTextL(sql, valText);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   338
 
<a name="l00387"></a>00387
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   339
 
<a name="l00388"></a>00388         <span class="comment">// Read F2 as binary. Expected value: zero-length 8-bit descriptor.</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   340
 
<a name="l00389"></a>00389         TBuf8&lt;10&gt; valBinary;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   341
 
<a name="l00390"></a>00390         err = fullSelectQuery.SelectBinaryL(sql, valBinary);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   342
 
<a name="l00391"></a>00391
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   343
 
<a name="l00392"></a>00392         <span class="comment">// Query with F4 column (text column) </span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   344
 
<a name="l00393"></a>00393         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSql4, <span class="stringliteral">&quot;SELECT F4 FROM A WHERE F1 = 1&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   345
 
<a name="l00394"></a>00394         sql.Copy(KSql4);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   346
 
<a name="l00395"></a>00395         <span class="comment">// Read F4 as integer. Expected value: 0.</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   347
 
<a name="l00396"></a>00396         valInt = fullSelectQuery.SelectIntL(sql);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   348
 
<a name="l00397"></a>00397
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   349
 
<a name="l00398"></a>00398         <span class="comment">//Read F4 as 64-bit integer. Expected value: 0.</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   350
 
<a name="l00399"></a>00399         valInt64 = fullSelectQuery.SelectInt64L(sql);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   351
 
<a name="l00400"></a>00400
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   352
 
<a name="l00401"></a>00401         <span class="comment">// Read F4 as real. Expected value: 0.0.</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   353
 
<a name="l00402"></a>00402         valReal = fullSelectQuery.SelectRealL(sql);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   354
 
<a name="l00403"></a>00403
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   355
 
<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>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   356
 
<a name="l00405"></a>00405         err = fullSelectQuery.SelectTextL(sql, valText);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   357
 
<a name="l00406"></a>00406
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   358
 
<a name="l00407"></a>00407         <span class="comment">// Read F4 as text. Big enough buffer. </span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   359
 
<a name="l00408"></a>00408         TBuf&lt;32&gt; valText2;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   360
 
<a name="l00409"></a>00409         err = fullSelectQuery.SelectTextL(sql, valText2);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   361
 
<a name="l00410"></a>00410
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   362
 
<a name="l00411"></a>00411         <span class="comment">// Read F4 as binary. Expected error: KErrNone. Zero-length 8-bit descriptor.</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   363
 
<a name="l00412"></a>00412         err = fullSelectQuery.SelectBinaryL(sql, valBinary);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   364
 
<a name="l00413"></a>00413
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   365
 
<a name="l00414"></a>00414         <span class="comment">// Read F5 as binary. Big enough buffer.</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   366
 
<a name="l00415"></a>00415         TBuf8&lt;100&gt; valBinary2;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   367
 
<a name="l00416"></a>00416         err = fullSelectQuery.SelectBinaryL(sql, valBinary2);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   368
 
<a name="l00417"></a>00417
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   369
 
<a name="l00418"></a>00418         <span class="comment">// Text column value, small buffer, reallocation </span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   370
 
<a name="l00419"></a>00419         HBufC* hbuf = <a class="code" href="class_c_sql_example.html#a8b115210a3fbfa19de5c7f6a0abf3e43">HBufC::NewLC</a>(10);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   371
 
<a name="l00420"></a>00420         TPtr name = hbuf-&gt;Des();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   372
 
<a name="l00421"></a>00421         sql.Copy(KSql4);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   373
 
<a name="l00422"></a>00422         err = fullSelectQuery.SelectTextL(sql, name);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   374
 
<a name="l00423"></a>00423
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   375
 
<a name="l00424"></a>00424         <span class="keywordflow">if</span>(err &gt; 0)
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   376
 
<a name="l00425"></a>00425                 {
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   377
 
<a name="l00426"></a>00426                 hbuf = hbuf-&gt;ReAllocL(err);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   378
 
<a name="l00427"></a>00427                 CleanupStack::Pop();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   379
 
<a name="l00428"></a>00428                 CleanupStack::PushL(hbuf);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   380
 
<a name="l00429"></a>00429                 name.Set(hbuf-&gt;Des());
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   381
 
<a name="l00430"></a>00430                 err = fullSelectQuery.SelectTextL(sql, name);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   382
 
<a name="l00431"></a>00431
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   383
 
<a name="l00432"></a>00432                 }
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   384
 
<a name="l00433"></a>00433         CleanupStack::PopAndDestroy(); <span class="comment">// hbuf, can&#39;t be put as parameter, because may be reallocated</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   385
 
<a name="l00434"></a>00434         <span class="comment">//Close database, delete database file.</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   386
 
<a name="l00435"></a>00435         db.Close();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   387
 
<a name="l00436"></a>00436         User::LeaveIfError(RSqlDatabase::Delete(KDatabase));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   388
 
<a name="l00437"></a>00437
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   389
 
<a name="l00438"></a>00438         }
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   390
 
<a name="l00439"></a>00439
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   391
 
<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>()
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   392
 
<a name="l00448"></a>00448         {
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   393
 
<a name="l00449"></a>00449         RSqlDatabase db;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   394
 
<a name="l00450"></a>00450         TInt error;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   395
 
<a name="l00451"></a>00451         User::LeaveIfError(db.Create(KDbName));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   396
 
<a name="l00452"></a>00452
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   397
 
<a name="l00453"></a>00453         <span class="comment">// Create a table</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   398
 
<a name="l00454"></a>00454         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSqlStmt1, <span class="stringliteral">&quot;CREATE TABLE A(Fld1 INTEGER, Fld2 BLOB);&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   399
 
<a name="l00455"></a>00455
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   400
 
<a name="l00456"></a>00456         User::LeaveIfError(error = db.Exec(KSqlStmt1));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   401
 
<a name="l00457"></a>00457         <span class="keyword">const</span> TInt KDataLen = 100;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   402
 
<a name="l00458"></a>00458
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   403
 
<a name="l00459"></a>00459         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSqlStmt2, <span class="stringliteral">&quot;INSERT INTO A(Fld1, Fld2) VALUES(&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   404
 
<a name="l00460"></a>00460
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   405
 
<a name="l00461"></a>00461         <span class="comment">// Allocate a buffer for the SQL statement.</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   406
 
<a name="l00462"></a>00462         HBufC8* buf = HBufC8::New(KSqlStmt2().Length() + KDataLen * 2 + 10);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   407
 
<a name="l00463"></a>00463
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   408
 
<a name="l00464"></a>00464         TPtr8 sql = buf-&gt;Des();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   409
 
<a name="l00465"></a>00465
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   410
 
<a name="l00466"></a>00466         <span class="comment">// Insert row 1</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   411
 
<a name="l00467"></a>00467
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   412
 
<a name="l00468"></a>00468         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KHexValStr1, <span class="stringliteral">&quot;7E&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   413
 
<a name="l00469"></a>00469         sql.Copy(KSqlStmt2);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   414
 
<a name="l00470"></a>00470
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   415
 
<a name="l00471"></a>00471         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KString1, <span class="stringliteral">&quot;1, x&#39;&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   416
 
<a name="l00472"></a>00472         sql.Append(KString1);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   417
 
<a name="l00473"></a>00473         TInt i;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   418
 
<a name="l00474"></a>00474         <span class="keywordflow">for</span>(i=0;i&lt;KDataLen;++i)
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   419
 
<a name="l00475"></a>00475                 {
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   420
 
<a name="l00476"></a>00476                 sql.Append(KHexValStr1);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   421
 
<a name="l00477"></a>00477                 }
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   422
 
<a name="l00478"></a>00478         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KString2, <span class="stringliteral">&quot;&#39;)&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   423
 
<a name="l00479"></a>00479         sql.Append(KString2);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   424
 
<a name="l00480"></a>00480
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   425
 
<a name="l00481"></a>00481         User::LeaveIfError(db.Exec(sql));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   426
 
<a name="l00482"></a>00482
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   427
 
<a name="l00483"></a>00483         <span class="comment">// Insert row 2</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   428
 
<a name="l00484"></a>00484
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   429
 
<a name="l00485"></a>00485         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KHexValStr2, <span class="stringliteral">&quot;A3&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   430
 
<a name="l00486"></a>00486         sql.Copy(KSqlStmt2);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   431
 
<a name="l00487"></a>00487         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KString3, <span class="stringliteral">&quot;2, x&#39;&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   432
 
<a name="l00488"></a>00488         sql.Append(KString3);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   433
 
<a name="l00489"></a>00489         <span class="keywordflow">for</span>(i=0;i&lt;KDataLen;++i)
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   434
 
<a name="l00490"></a>00490                 {
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   435
 
<a name="l00491"></a>00491                 sql.Append(KHexValStr2);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   436
 
<a name="l00492"></a>00492                 }
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   437
 
<a name="l00493"></a>00493         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KString4, <span class="stringliteral">&quot;&#39;)&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   438
 
<a name="l00494"></a>00494         sql.Append(KString4);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   439
 
<a name="l00495"></a>00495
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   440
 
<a name="l00496"></a>00496         User::LeaveIfError(db.Exec(sql));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   441
 
<a name="l00497"></a>00497
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   442
 
<a name="l00498"></a>00498         <span class="comment">// Prepare SELECT SQL statement</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   443
 
<a name="l00499"></a>00499         <a class="code" href="secureclientandserver_8h.html#a5eadd4429627d82193b37536d4faa03a">_LIT</a>(KSqlStmt3, <span class="stringliteral">&quot;SELECT * FROM A&quot;</span>);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   444
 
<a name="l00500"></a>00500
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   445
 
<a name="l00501"></a>00501         RSqlStatement stmt;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   446
 
<a name="l00502"></a>00502         User::LeaveIfError(error = stmt.Prepare(db, KSqlStmt3));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   447
 
<a name="l00503"></a>00503
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   448
 
<a name="l00504"></a>00504         <span class="comment">// Move on row 1</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   449
 
<a name="l00505"></a>00505         User::LeaveIfError(error = stmt.Next());
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   450
 
<a name="l00506"></a>00506
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   451
 
<a name="l00507"></a>00507         <span class="comment">// Read the long binary column using a stream</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   452
 
<a name="l00508"></a>00508         RSqlColumnReadStream columnStream;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   453
 
<a name="l00509"></a>00509         error = columnStream.ColumnBinary(stmt, 1);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   454
 
<a name="l00510"></a>00510
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   455
 
<a name="l00511"></a>00511
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   456
 
<a name="l00512"></a>00512         TInt size = stmt.ColumnSize(1);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   457
 
<a name="l00513"></a>00513         TPtr8 colData = buf-&gt;Des();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   458
 
<a name="l00514"></a>00514         TRAP(error, columnStream.ReadL(colData, size));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   459
 
<a name="l00515"></a>00515         columnStream.Close();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   460
 
<a name="l00516"></a>00516
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   461
 
<a name="l00517"></a>00517         User::LeaveIfError(stmt.Next());
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   462
 
<a name="l00518"></a>00518
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   463
 
<a name="l00519"></a>00519         <span class="comment">//Read row 2 using ColumnBinary(TInt aColumnIndex, TDes8&amp; aDest).</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   464
 
<a name="l00520"></a>00520         error = stmt.ColumnBinary(1, colData);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   465
 
<a name="l00521"></a>00521
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   466
 
<a name="l00522"></a>00522         <span class="comment">//Read row 2 using a stream</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   467
 
<a name="l00523"></a>00523         colData.Zero();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   468
 
<a name="l00524"></a>00524         error = columnStream.ColumnBinary(stmt, 1);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   469
 
<a name="l00525"></a>00525
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   470
 
<a name="l00526"></a>00526         size = stmt.ColumnSize(1);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   471
 
<a name="l00527"></a>00527         TRAP(error, columnStream.ReadL(colData, size));
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   472
 
<a name="l00528"></a>00528         columnStream.Close();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   473
 
<a name="l00529"></a>00529
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   474
 
<a name="l00530"></a>00530         stmt.Close();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   475
 
<a name="l00531"></a>00531
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   476
 
<a name="l00532"></a>00532         <span class="keyword">delete</span> buf;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   477
 
<a name="l00533"></a>00533         buf = NULL;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   478
 
<a name="l00534"></a>00534
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   479
 
<a name="l00535"></a>00535         db.Close();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   480
 
<a name="l00536"></a>00536
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   481
 
<a name="l00537"></a>00537         error = RSqlDatabase::Delete(KDbName);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   482
 
<a name="l00538"></a>00538
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   483
 
<a name="l00539"></a>00539         }
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   484
 
<a name="l00540"></a>00540
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   485
 
<a name="l00541"></a>00541
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   486
 
<a name="l00542"></a><a class="code" href="sqlexample_8cpp.html#a689e0bf9aa924a1d7dc108665d44736c">00542</a> LOCAL_C <span class="keywordtype">void</span> MainL()
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   487
 
<a name="l00543"></a>00543         {
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   488
 
<a name="l00544"></a>00544         <span class="comment">// Create an Active Scheduler to handle asychronous calls</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   489
 
<a name="l00545"></a>00545         CActiveScheduler* scheduler = <span class="keyword">new</span> (ELeave) CActiveScheduler;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   490
 
<a name="l00546"></a>00546         CleanupStack::PushL(scheduler);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   491
 
<a name="l00547"></a>00547         CActiveScheduler::Install( scheduler );
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   492
 
<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>();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   493
 
<a name="l00549"></a>00549
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   494
 
<a name="l00550"></a>00550         <span class="comment">// Create a non secure database</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   495
 
<a name="l00551"></a>00551         app-&gt;<a class="code" href="class_c_sql_example.html#af0523fb9c7a711a2c7745e8d2e96faa7">CreateNonSecureDBL</a>();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   496
 
<a name="l00552"></a>00552
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   497
 
<a name="l00553"></a>00553         <span class="comment">// Create and open a secure database</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   498
 
<a name="l00554"></a>00554         app-&gt;<a class="code" href="class_c_sql_example.html#a2d2358e96bba71900cedd067fe44192b">CreateAndOpenSecureDBL</a>();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   499
 
<a name="l00555"></a>00555
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   500
 
<a name="l00556"></a>00556         <span class="comment">// Copy two databases</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   501
 
<a name="l00557"></a>00557         app-&gt;<a class="code" href="class_c_sql_example.html#a1a6247133748297a2a8877381583e51c">CopyDatabaseL</a>();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   502
 
<a name="l00558"></a>00558
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   503
 
<a name="l00559"></a>00559         <span class="comment">// Attach two databases</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   504
 
<a name="l00560"></a>00560         app-&gt;<a class="code" href="class_c_sql_example.html#adf02168d537e9e1650d5f379522a6b2e">AttachDatabasesL</a>();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   505
 
<a name="l00561"></a>00561
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   506
 
<a name="l00562"></a>00562         <span class="comment">// Simple query and query with paramaters</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   507
 
<a name="l00563"></a>00563         app-&gt;<a class="code" href="class_c_sql_example.html#a49067abc75f826bfd43be44c07460c7b">DataTypesQueryL</a>();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   508
 
<a name="l00564"></a>00564
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   509
 
<a name="l00565"></a>00565         <span class="comment">//Prepares and executes a query with a large parameter</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   510
 
<a name="l00566"></a>00566         <span class="comment">// writing that parameter using streaming (RParamWriteStream)</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   511
 
<a name="l00567"></a>00567         app-&gt;<a class="code" href="class_c_sql_example.html#a7fac459ccd95278c1af4eb50e5453812">ScalarFullSelectL</a>();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   512
 
<a name="l00568"></a>00568
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   513
 
<a name="l00569"></a>00569         <span class="comment">// Prepare and execute a query which returns data,</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   514
 
<a name="l00570"></a>00570         <span class="comment">// and read that data using streaming (RColumnReadStream)</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   515
 
<a name="l00571"></a>00571         app-&gt;<a class="code" href="class_c_sql_example.html#a12e036a57115aceb1c64545fc9dee052">ColumnBinaryStreamL</a>();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   516
 
<a name="l00572"></a>00572
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   517
 
<a name="l00573"></a>00573         CleanupStack::PopAndDestroy(2); <span class="comment">//app, scheduler</span>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   518
 
<a name="l00574"></a>00574
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   519
 
<a name="l00575"></a>00575         }
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   520
 
<a name="l00576"></a>00576
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   521
 
<a name="l00577"></a><a class="code" href="sqlexample_8cpp.html#a0f358e9c4355138f629b8c4f37310295">00577</a> GLDEF_C TInt E32Main()
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   522
 
<a name="l00578"></a>00578         {
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   523
 
<a name="l00579"></a>00579     __UHEAP_MARK;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   524
 
<a name="l00580"></a>00580     CTrapCleanup* cleanup = CTrapCleanup::New();
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   525
 
<a name="l00581"></a>00581     <span class="keywordflow">if</span>(cleanup == NULL)
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   526
 
<a name="l00582"></a>00582         {
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   527
 
<a name="l00583"></a>00583         <span class="keywordflow">return</span> KErrNoMemory;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   528
 
<a name="l00584"></a>00584         }
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   529
 
<a name="l00585"></a>00585     TRAPD(err, MainL());
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   530
 
<a name="l00586"></a>00586         <span class="keywordflow">if</span>(err != KErrNone)
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   531
 
<a name="l00587"></a>00587                 {
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   532
 
<a name="l00588"></a>00588                 User::Panic(_L(<span class="stringliteral">&quot;Failed to complete&quot;</span>),err);
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   533
 
<a name="l00589"></a>00589                 }
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   534
 
<a name="l00590"></a>00590
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   535
 
<a name="l00591"></a>00591     <span class="keyword">delete</span> cleanup;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   536
 
<a name="l00592"></a>00592     __UHEAP_MARKEND;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   537
 
<a name="l00593"></a>00593     <span class="keywordflow">return</span> KErrNone;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   538
 
<a name="l00594"></a>00594         }
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   539
 
</pre></div></div>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   540
 
<hr size="1"/><address style="text-align: right;"><small>Generated by&nbsp;
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   541
 
<a href="http://www.doxygen.org/index.html">
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   542
 
<img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.6.2 </small></address>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   543
 
</body>
43e37759235e Week 12 contribution of example code"
Dominic Pinkman <Dominic.Pinkman@Nokia.com>
parents:
diff changeset 
   544
 
</html>
MCL/sftools/depl/docscontent