diff -r 4816d766a08a -r f345bda72bc4 Symbian3/PDK/Source/GUID-B61EA8C5-0966-51DE-AC73-01DD34C7D3CC.dita --- a/Symbian3/PDK/Source/GUID-B61EA8C5-0966-51DE-AC73-01DD34C7D3CC.dita Tue Mar 30 11:42:04 2010 +0100 +++ b/Symbian3/PDK/Source/GUID-B61EA8C5-0966-51DE-AC73-01DD34C7D3CC.dita Tue Mar 30 11:56:28 2010 +0100 @@ -1,13 +1,34 @@ - - - - - -Deleting Rows from a Table

This tutorial describes how to delete rows from a database table.

Introduction

The deletion of a record from a database can be performed by executing the DELETE SQL statement. The query does not pass or return any data.

Basic procedure

  • Configure the SQL statement

  • Execute the statement.

Detailed steps

Configure the SQL statement

Create a literal for your DELETE statement. You do not need to create a RSqlStatement object to run a DELETE statement. You need to just execute the query with the RSqlDatabase object, which has its own RSqlDatabase::Exec() function taking a query string as its parameter.

_LIT(kQueryString,"DELETE FROM countries WHERE population < 2;"); -

NOTE : It is possible to call a DELETE statement from an RSqlStatement object, but it is computationally more expensive and you are recommended not to do so.

Execute the statement

Execute the DELETE statement. This code assumes that the countriesDatabase object is open.

countriesDatabase.Exec(kQueryString);
See also

Querying a Database

Inserting a Row into a Table

Deleting Rows from a Table - This document

Reading to a Buffer

Reading to Memory

Reading to a Data Stream

Writing to a Data Stream

Performing Scalar Queries

\ No newline at end of file + + + + + +Deleting +Rows from a TableThis tutorial describes how to delete rows from a database table. +
Introduction

The deletion of a record from a database +can be performed by executing the DELETE SQL statement. The +query does not pass or return any data.

+
Basic procedure
    +

  • Configure the SQL statement

    • +

  • Execute the statement.

    • +
+
Detailed steps

Configure +the SQL statement

Create a literal for your DELETE statement. +You do not need to create a RSqlStatement object to run +a DELETE statement. You need to just execute the query with +the RSqlDatabase object, which has its own RSqlDatabase::Exec() function +taking a query string as its parameter.

_LIT(kQueryString,"DELETE FROM countries WHERE population < 2;"); +

NOTE : It is possible to call a DELETE statement +from an RSqlStatement object, but it is computationally +more expensive and you are recommended not to do so.

Execute the statement

Execute the DELETE statement. +This code assumes that the countriesDatabase object is open.

countriesDatabase.Exec(kQueryString);
+
See also

Querying +a Database

Inserting +a Row into a Table

Deleting Rows from a Table - This document

Reading to a Buffer

Reading to Memory

Reading to a Data Stream

Writing to a Data Stream

Performing Scalar Queries

+ \ No newline at end of file