Databases are widely used for storing and processing data and there is the possibility to use databases in UIQ 2.1 smartphones. There is a well established database API so you can freely use its features in your applications. This application shows how you can use this technology by creating a DB file and managing it with a few simple functions.

Download example application>>

The example application shows the most basic and common functionality. Much more advanced features can be of course implemented. This example enables:

• Open or create a DB file
• Close as well as remove a database
• Add/remove tables
• Add/remove/edit data in tables

All of the basic functionality can be easily expanded with the new features. This application has a very simple graphical interface and does not complicate the most important features, that is working with databases.

The user has many options. The DB can be opened from existing files or a new file can be created. The user can create some demo tables or create one manually. Tables have their names listed in the mail window.

After tapping on the table name, its content is displayed. It is empty initially but some demo data can be inserted.

Manually inserting of data is also possible. Data can be also updated with the same dialog.

To build the MyDbApp example for a Sony Ericsson smartphone:

$ bldmake bldfiles
$ abld build thumb urel
$ makesis MyDbApp.pkg

More information:

• More information about contacts can be found in the UIQ 2.1 SDK, (look for DBMS) at:
  » UIQ 2.1 SDK » Developer Library » API Reference » C++ API reference
• Symbian website>>