Basics: +demonstrates basic use of the Symbian platform DBMS

Description

This is an example of database manipulation +using the DBMS.

Initially the database is created as a permanent file +store, using CFileStore routines. A table ("CDs") is created +with three fields ("Artist", "Title" and "Price") and this is then indexed +on the "Artist" and "Title" fields.

To prove the correct action of +the previous code, the example iterates through the database, printing the +contents to the console. Finally, the database is closed and +the example exits.

Download

Download the example: Basics.zip

Download some additional files required +by the example: CommonFramework.zip

View the source code: browse. View the additional files: browse

Usage

The example should be run from the command +line with no parameters.

Class summary

RDbView - Generates rowsets from an SQL query. The +query is prepared and evaluated using the interface to this class, while the +rowset is manipulated using the RDbRowset base class.
RDbStoreDatabase - DBMS Store database implementation.
TDbCol - Defines a column in a table or rowset.
TDbKeyCol - Defines a key column in an index.
CDbColSet - Manages a set of column definitions +which describe a table or rowset structure. Column definitions can be added +and removed. The set can be iterated over, and ordinals for a column can be +looked up.
RDbRowSet - An abstract base class that provides +functionality which is shared between SQL view objects and Table objects.
CDbKey - Represents the definition of an index.
TParse
TStreamId - Provides unique identification for stream +within a store.
CFileStore - File based persistent store abstract +base class.