Symbian3/SDK/Source/GUID-BDC03973-45B0-54BD-99D1-298F4F59DB95.dita
changeset 7 51a74ef9ed63
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Symbian3/SDK/Source/GUID-BDC03973-45B0-54BD-99D1-298F4F59DB95.dita	Wed Mar 31 11:11:55 2010 +0100
@@ -0,0 +1,44 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- Copyright (c) 2007-2010 Nokia Corporation and/or its subsidiary(-ies) All rights reserved. -->
+<!-- This component and the accompanying materials are made available under the terms of the License 
+"Eclipse Public License v1.0" which accompanies this distribution, 
+and is available at the URL "http://www.eclipse.org/legal/epl-v10.html". -->
+<!-- Initial Contributors:
+    Nokia Corporation - initial contribution.
+Contributors: 
+-->
+<!DOCTYPE concept
+  PUBLIC "-//OASIS//DTD DITA Concept//EN" "concept.dtd">
+<concept id="GUID-BDC03973-45B0-54BD-99D1-298F4F59DB95" xml:lang="en"><title>How
+to execute SQL incrementally</title><shortdesc>Describes how SQL statements are executed.</shortdesc><prolog><metadata><keywords/></metadata></prolog><conbody>
+<p>DDL and DML statements can be executed incrementally.</p>
+<section id="GUID-98969CFF-05CB-44AC-B104-55BAB017FF95"><title>Incremental execution of a DDL statement</title> <p>The following
+code fragment illustrates the incremental execution of a DDL statement. In
+practice, this is no better than direct execution but shows the 'end conditions'
+for running <codeph>RDbIncremental</codeph>.</p> <codeblock id="GUID-BC862C15-ACC4-5D29-A814-358C88116B6F" xml:space="preserve">_LIT(KTxt,"DROP TABLE Suppliers");
+...
+RDbIncremental op;
+TInt step;
+TInt r=op.Execute(database,KTxt,step);
+while (step&gt;0 &amp;&amp; r==KErrNone)
+    {
+    r=op.Next(step);
+    }
+op.Close();
+...
+// r has the error code from the operation</codeblock> </section>
+<section id="GUID-49F5A5A9-34FB-4493-BD1E-A6DA8AFC23F9"><title>Incremental execution of a DML statement</title> <p>The following
+code fragment is an example of driving the incremental execution of a DML
+statement to completion.</p> <codeblock id="GUID-F25A1017-B103-530C-B426-54098A696014" xml:space="preserve">_LIT(KTxt,"DELETE FROM Suppliers");
+...
+RDbUpdate update;
+TInt r=update.Execute(database,KTxt);
+while (r&gt;0)
+    {
+    r=op.Next();
+    }
+op.Close();
+...
+// r has the error code from the operation
+// update.RowCount() returns the number of rows deleted, if successful</codeblock> </section>
+</conbody></concept>
\ No newline at end of file