A journey of a thousand miles starts with a single step.
Symbian SQL is easy to learn and straightforward to use. This chapter aims to provide everything needed to start using it. The first section in this chapter provides details of where and how to get Symbian SQL. Basic database operations are then demonstrated in a console application example. Finally, the location of additional documentation is listed.
Symbian SQL is included with SDKs based on Symbian OS v9.3 onwards, including all Symbian Foundation releases. From the device perspective, Symbian SQL is included in S60 3rd Edition Feature Pack 2 onwards. For users of S60 3rd Edition Feature Pack 1, Symbian SQL can be downloaded in a SIS file from the Symbian Foundation developer website at
developer.symbian.org. Additional releases may be supported in the future. Please check the wiki page for this book (
developer.symbian.org/wiki/index.php/InsideSymbianSQL) for more details.
Symbian SQL consists of two main classes along with other classes used for streaming binary large objects (BLOBs), binding columns, defining security polices and providing utility functions.
The two most important classes are as follows:
RSqlDatabase enables a client to create, open and attach to a database and to execute queries which do not require data to be returned (e.g. INSERT queries).
RSqlStatement enables a client to execute queries, including ones which return ...