diff -r 43e37759235e -r 51a74ef9ed63 Symbian3/SDK/Source/GUID-B38EBDBA-2A30-5595-9639-6AE58C530DCB.dita --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/Symbian3/SDK/Source/GUID-B38EBDBA-2A30-5595-9639-6AE58C530DCB.dita Wed Mar 31 11:11:55 2010 +0100 @@ -0,0 +1,83 @@ + + + + + +Creating +a Database This document shows you how to create a database for Symbian SQL. + + +

Working with databases +is not possible until the database exists. In this tutorial you will learn +how to create a simple database.

This tutorial uses code from the Basic SQL example application.

The +SQL statement used for this tutorial is shown here:

CREATE DATABASE \\Basic_db.db + +Declare a constant +to hold the database handle: + + KDatabaseName will be used when creating and accessing +the database. +_LIT(KDatabaseName, "\\Basic_db.db"); +_LIT(KDatabaseMsg,"\nCreating a database\n"); +RSqlDatabase db; +CConsoleBase* iConsole; +The objects and constants needed to create the database are now +ready. + +Create the database: + +You are telling Symbian SQL to execute the CREATE DATABASE command. +iConsole->Printf(KDatabaseMsg); +User::LeaveIfError(db.Create(KDatabaseName)); +iConsole->Printf(KDatabaseName); +The database now exists. RSqlDatabase::Create() executes +the SQL engine command that makes the actual database. You can look in the C:\ drive +on the device to confirm that the database object exists. + + +

The database now +exists. You can perform all the standard SQL operations on the database including +creating and populating a table, querying the database, editing records and +deleting the database, to name a few.

+Create database +example

The following code snippet is from the example code used +for this tutorial:

... +_LIT(KDatabaseName, "\\Basic_db.db"); +_LIT(KDatabaseMsg,"\nCreating a database\n"); +... +CConsoleBase* iConsole; +... +void CBasicSqlExample::CreateDatabaseL() + { + RSqlDatabase db; + + iConsole->Printf(KDatabaseMsg); + //create the database + User::LeaveIfError(db.Create(KDatabaseName)); + + iConsole->Printf(KDatabaseName); + CleanupClosePushL(db); + ... + } +

Now that you have +created a database you need to add a table and populate it with some data. +The following will show you how:

    +

  • Creating +a Table

    • +

  • Inserting +Data into a Table

    • +

  • Writing +from a Data Stream

    • +
 + +SQL Overview + +Basic SQL +Example Application + \ No newline at end of file