S60 Platform: DBMS Example v2.0
-------------------------------------------------

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 complements the "S60 Platform: Using DBMS APIs v2.0" document published at Forum Nokia.

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

PREREQUISITES

Symbian C++ basics

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

IMPORTANT FILES/CLASSES

DBMSEngine.h:
It demonstrates the following DBMS features:
  
- Creating, opening, and removing a database
- Creating and dropping a table; creating an index
- Retrieving, updating, removing, and adding books using both 
  the C++ API and SQL.
- Querying and modifying database structure
- Incremental operations both synchronously and asynchronously


Important Symbian C++ classes: RDbStoreDatabase, RFs

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

KNOWN ISSUES

No known issues.
    
--------------------------------------------------------------------------------

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 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

The steps for building and installing the application to a device depend on the S60 platform version:

--Mobile device (S60 3rd Edition)
    cd to /DBMS/group
    bldmake bldfiles
    abld build gcce urel
    cd to /DBMS/sis
    Edit the DBMS_S60_3rd_ed.pkg's paths to match those on your system.
    makesis DBMS_S60_3rd_ed.pkg
    
    Sign the SIS package 
      - See the SDK Help for information about self-signed .sis packages, or
        www.symbiansigned.com for information about Developer Certificates.

    Install the signed .sis file to an S60 3rd Edition device.
    
--Mobile device (S60 1st and 2nd Edition)
    cd to /DBMS/group
    bldmake bldfiles
    abld build armi urel
    cd to /DBMS/sis
    Edit the DBMS_S60_2nd_ed.pkg's (or DBMS_S60_1st_ed.pkg's) paths to match those on your system.
    makesis DBMS_S60_2nd_ed.pkg's (or DBMS_S60_1st_ed.pkg)
    Install the SIS file to the device.

--Emulator (WINSCW)
    cd to /DBMS/group
    bldmake bldfiles
    abld build winscw udeb
    Start the emulator.
    
--------------------------------------------------------------------------------

COMPATIBILITY

S60 3rd Edition
S60 2nd Edition
S60 1st Edition

TESTED WITH Nokia 3650, Nokia 6670, Nokia E60
Created / tested with Series 60 SDK 1.2 for Symbian OS, Supporting Metrowerks Codewarrior 
for Symbian OS
and with Series 60 2nd Edition SDK for Symbian OS, Supporting Feature Pack 2, for C++, 
Supporting Metrowerks CodeWarrior
and with S60 3rd Edition SDK for Symbian OS, for C++, Supporting Metrowerks CodeWarrior

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

VERSION HISTORY		

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 at
http://www.forum.nokia.com/main/1%2C%2C90%2C00.html?surveyId=5e8d013f-d81d-4089-a34c-76858c3a0b58/S60_Platform_DBMS_Example_v2_0_en.zip