S60 Platform: DBMS Example v2.1

-------------------------------------------------

 

The DBMS (Database Management System) example application demonstrates the

usage of DBMS APIs. The example includes a bookstore database engine and a

simple Avkon GUI for testing the engine. The example has been tested to

 be compatible with S60 5th Edition and touch UI.

 

The example complements the "S60 Platform: Using DBMS APIs v2.0" document

available at Forum Nokia.

 

 

PREREQUISITES

-------------------------------------------------------------------------------

 

Symbian C++ basics.

 

 

IMPORTANT FILES/CLASSES

-------------------------------------------------------------------------------

 

src\DBMSEngine.cpp

    1) Creating, opening, and removing a database.

    2) Creating and dropping a table; creating an index.

    3) Retrieving, updating, removing, and adding books using both the C++ API

        and SQL.

    4) Querying and modifying database structure.

    5) Incremental operations both synchronously and asynchronously.

 

Important Symbian C++ classes: RDbStoreDatabase, RFs

 

 

KNOWN ISSUES

-------------------------------------------------------------------------------

 

No known issues.

   

 

TOUCH UI SUPPORT

-------------------------------------------------------------------------------

 

No changes were needed to ensure touch UI support.

 

RUNNING THE EXAMPLE

-------------------------------------------------------------------------------

 

When the application is started, choose the 'Options' menu and create a new

database. When the database has been created, add the book information to the

database by choosing 'Add a book' from the 'Options' menu. Other functions are

Remove, Remove all books, Change title, Get all books, Multiple search,

Details, and Get columns.

 

 

BUILD & INSTALLATION INSTRUCTIONS

-------------------------------------------------------------------------------

 

Steps for building and installing the application to a device depend on the S60

platform version:

 

Mobile device

~~~~~~~~~~~~~

 

1. Make sure the paths in .pkg files match those on your system.

 

2. Compile the example:

 

    cd group

    bldmake bldfiles

    abld reallyclean gcce

    abld build gcce urel

 

3. Make the sis:

 

    cd sis

    createsis create DBMS_S60_3_0_v_2_1_0.pkg

   

4. Install the signed .sis file to an S60 3rd Edition device.

   - If you get a "Certificate error" during installation of a self-signed

     package, check that App.Manager -> Settings -> Software Installation is

     set to "All."

 

Emulator (WINSCW)

~~~~~~~~~~~~~~~~~

 

1. Compile the example:

 

    cd group

    bldmake bldfiles

    abld reallyclean winscw

    abld build winscw udeb

 

2. Start the emulator.

       

 

COMPATIBILITY

-------------------------------------------------------------------------------

 

S60 5th Edition

S60 3rd Edition, Feature Pack 2

S60 3rd Edition, Feature Pack 1

S60 3rd Edition, Maintenance Release

 

Tested with Nokia 5800 XpressMusic, Nokia N93, Nokia 6220 Classic, Nokia N95 8GB.

 

Developed and tested with:

S60 5th Edition

S60 3rd Edition SDK for Symbian OS, supporting Feature Pack 2, for C++

S60 3rd Edition SDK for Symbian OS, supporting Feature Pack 1, for C++

S60 3rd Edition SDK for Symbian OS, for C++, Maintenance Release

 

 

VERSION HISTORY    

-------------------------------------------------------------------------------

 

2.1     Multiple search command fixed  

        Tested to be compatible with S60 5th Edition and touch UI. Support for S60 1st and 2nd Edition dropped.

 

2.0     The example ported to S60 3rd Edition.

        S60 1st and 2nd Editions also supported (v1.0 DBMS examples were merged

        into this version). The example renamed from BookStore to DBMS

        (Database Management System).

 

1.0     First releases published (for S60 1st and 2nd Editions):

        Series 60 Developer Platform 2.0: DBMS Example v1.0 (March 11, 2004)

        Series 60 Developer Platform 1.0: DBMS Example v1.0 (September 1, 2003)

 

 

EVALUATE THIS RESOURCE

-------------------------------------------------------------------------------

 

Please spare a moment to help us improve documentation quality and recognize

the examples you find most valuable, by rating this resource.