S60 Platform: Using DBMS APIs v2.0
| file name: |
S60_Platform_Using_DBMS_APIs_v2_0_en.pdf
| |
| description: |
This C++ document demonstrates how to use the relational database APIs available on Symbian OS. Collectively, this functionality is known as the Database Management System (DBMS) APIs. Symbian OS DBMS provides features for creating and maintaining databases, and implements reliable and secure data access to these databases via both native and SQL calls. These calls are supported by a transaction/rollback mechanism that ensures that either all data is written or none at all. The document provides a sample of code snippets from “S60 Platform: DBMS Example” to demonstrate key techniques by creating and manipulating a simple database of books. The code snippets embedded throughout the document are predominantly gathered or adapted from this example. Although the document focuses specifically on describing the support of DBMS APIs in the S60 platform, it is mostly applicable to other Symbian OS devices too.
| |
| date of publication: |
2006-07-04
| |
| type: |
Document
| |
| topics: |
Files/Data
S60 Symbian C++ | |
| language: |
English (en)
| |
| encoding: |
Adobe PDF (.pdf)
| |
| intended audience: |
Intermediate
| |
| see also: |
S60 Platform: DBMS Example v2.0
| |
|
|
||
Additional information
| distribution: |
Forum Nokia Global Web Site
S60 Web Site |
| edition: |
2
|
| editorial revision: |
0
|
| rights: |
Copyright © 2004-2006 Nokia Corporation.
|
| size: |
420 KB
|
| supersedes: |
Symbian OS: Using DBMS APIs v1.0
|
RDF Facets:
qdcZdateQDx2006E2d06E2d26X
qdcZdateQDx2006E2d07E2d03X
qdcZdescriptionQSxThisE20CE2bE2bE20documentE20demonstratesE20howE20toE20useE20theE20relationalE20databaseE20APIsE20availableE20onE20SymbianE20OSE2eE20CollectivelyE2cE20thisE20functionalityE20isE20knownE20asE20theE20E44atabaseE20ManagementE20SystemE20E28E44BMSE29E20APIsE2eE20SymbianE20OSE20E44BMSE20providesE20featuresE20forE20creatingE20andE20maintainingE20databasesE2cE20andE20implementsE20reliableE20andE20secureE20dataE20accessE20toE20theseE20databasesE20viaE20bothE20nativeE20andE20SE51E4cE20callsE2eE20TheseE20callsE20areE20supportedE20byE20aE20transactionE2frollbackE20mechanismE20thatE20ensuresE20thatE20eitherE20allE20dataE20isE20writtenE20orE20noneE20atE20allE2eE20TheE20documentE20providesE20aE20sampleE20ofE20codeE20snippetsE20fromE20E93S60E20PlatformE3aE20E44BMSE20E45E78ampleE94E20toE20demonstrateE20keyE20techniE71uesE20byE20creatingE20andE20manipulatingE20aE20simpleE20databaseE20ofE20booksE2eE20TheE20codeE20snippetsE20embeddedE20throughoutE20theE20documentE20areE20predominantlyE20gatheredE20orE20adaptedE20fromE20thisE20eE78ampleE2eE20AlthoughE20theE20documentE20focusesE20specificallyE20onE20describingE20theE20supportE20ofE20E44BMSE20APIsE20inE20theE20S60E20platformE2cE20itE20isE20mostlyE20applicableE20toE20otherE20SymbianE20OSE20devicesE20tooE2eX
qdcZformatQNx429733X
qdcZidentifierQSxhttpE3aE2fE2fswE2enokiaE2ecomE2fidE2fe0a66f34E2d092aE2d4a52E2d8003E2d6bbc3aa83c8fE2fS60E5fPlatformE5fUsingE5fE44BMSE5fAPIsE5fv2E5f0E5fenE2epdfX
qdcZrelationQUxhttpE3aE2fE2fswE2enokiaE2ecomE2fidE2f5e8d013fE2dd81dE2d4089E2da34cE2d76858c3a0b58E2fS60E5fPlatformE5fE44BMSE5fE45E78ampleE5fv2E5f0E5fenE2ezipX
qdcZtitleQSxS60E20PlatformE3aE20UsingE20E44BMSE20APIsE20v2E2e0X
qdcZtypeQUqfnZE45E78cludedFromGeneralE4cistingsQ
qdcZtypeQUqfnTypeZE44ocumentQ
qdcZtypeQUqfnTypeZE52esourceQ
qdcZtypeQUqmarsZManagedE52esourceQ
qdcZtypeQUqwebZInformationE52esourceQ
qdcZtypeQUqwebZE52esourceQ
qdcZtypeQUqrdfsZE52esourceQ
qdctermsZeE78tentQNx429733X
qdctermsZissuedQDx2006E2d06E2d26X
qdctermsZmodifiedQDx2006E2d07E2d03X
qrssZdescriptionQSxThisE20CE2bE2bE20documentE20demonstratesE20howE20toE20useE20theE20relationalE20databaseE20APIsE20availableE20onE20SymbianE20OSE2eE20CollectivelyE2cE20thisE20functionalityE20isE20knownE20asE20theE20E44atabaseE20ManagementE20SystemE20E28E44BMSE29E20APIsE2eE20SymbianE20OSE20E44BMSE20providesE20featuresE20forE20creatingE20andE20maintainingE20databasesE2cE20andE20implementsE20reliableE20andE20secureE20dataE20accessE20toE20theseE20databasesE20viaE20bothE20nativeE20andE20SE51E4cE20callsE2eE20TheseE20callsE20areE20supportedE20byE20aE20transactionE2frollbackE20mechanismE20thatE20ensuresE20thatE20eitherE20allE20dataE20isE20writtenE20orE20noneE20atE20allE2eE20TheE20documentE20providesE20aE20sampleE20ofE20codeE20snippetsE20fromE20E93S60E20PlatformE3aE20E44BMSE20E45E78ampleE94E20toE20demonstrateE20keyE20techniE71uesE20byE20creatingE20andE20manipulatingE20aE20simpleE20databaseE20ofE20booksE2eE20TheE20codeE20snippetsE20embeddedE20throughoutE20theE20documentE20areE20predominantlyE20gatheredE20orE20adaptedE20fromE20thisE20eE78ampleE2eE20AlthoughE20theE20documentE20focusesE20specificallyE20onE20describingE20theE20supportE20ofE20E44BMSE20APIsE20inE20theE20S60E20platformE2cE20itE20isE20mostlyE20applicableE20toE20otherE20SymbianE20OSE20devicesE20tooE2eX
qrssZtitleQSxS60E20PlatformE3aE20UsingE20E44BMSE20APIsE20v2E2e0X
qeditorZdescriptionE5fcreatedQDx2006E2d06E2d26X
qeditorZdescriptionE5fmodifiedQDx2006E2d07E2d03X
qeditorZtypeQUqfnTypeZE44ocumentQ
qeditorZtypeQUqfnTypeZE52esourceQ
qfnZallowedE5fcountryE5fgroupQUqfnCountryGroupZBQ
qfnZaudienceQUqfnAudienceZintermediateQRqmarsZrelevanceQNx100X
qfnZaudienceQUqfnAudienceZtechnicalQRqmarsZrelevanceQNx100X
qfnZdistributionQUxhttpE3aE2fE2fforumE2enokiaE2ecomE2fX
qfnZdistributionQUxhttpE3aE2fE2fwwwE2es60E2ecomE2fX
qfnZeE78portE5fcontrolE5fcommodityE5fnumberQSx99X
qfnZfilenameQSxS60E5fPlatformE5fUsingE5fE44BMSE5fAPIsE5fv2E5f0E5fenE2epdfX
qfnZpublishedQDx2006E2d07E2d04X
qfnZrepresentationQLqeditorZAttachmentQxS60E5fPlatformE5fUsingE5fE44BMSE5fAPIsE5fv2E5f0E5fenE2epdfX
qfnZtopicQUqfnTopicZcppQRqmarsZrelevanceQNx100X
qfnZtopicQUqfnTopicZfilesE5fdataQRqmarsZrelevanceQNx100X
qfnZtopicQUqfnTopicZseriesE5f60QRqmarsZrelevanceQNx100X
qfnZtypeQUqfnTypeZE44ocumentQ
qfnZtypeQUqfnTypeZE52esourceQ
qfnZupdatedQDx2006E2d07E2d04X
qfnZusE5foriginQLqE78sdZbooleanQxtrueX
qfnZuserE5ftagQSxfilesE2fdataX
qfnZuserE5ftagQSxs60X
qfnZuserE5ftagQSxsymbianE2dcE2bE2bX
qmarsZdescriptionQSxThisE20CE2bE2bE20documentE20demonstratesE20howE20toE20useE20theE20relationalE20databaseE20APIsE20availableE20onE20SymbianE20OSE2eE20CollectivelyE2cE20thisE20functionalityE20isE20knownE20asE20theE20E44atabaseE20ManagementE20SystemE20E28E44BMSE29E20APIsE2eE20SymbianE20OSE20E44BMSE20providesE20featuresE20forE20creatingE20andE20maintainingE20databasesE2cE20andE20implementsE20reliableE20andE20secureE20dataE20accessE20toE20theseE20databasesE20viaE20bothE20nativeE20andE20SE51E4cE20callsE2eE20TheseE20callsE20areE20supportedE20byE20aE20transactionE2frollbackE20mechanismE20thatE20ensuresE20thatE20eitherE20allE20dataE20isE20writtenE20orE20noneE20atE20allE2eE20TheE20documentE20providesE20aE20sampleE20ofE20codeE20snippetsE20fromE20E93S60E20PlatformE3aE20E44BMSE20E45E78ampleE94E20toE20demonstrateE20keyE20techniE71uesE20byE20creatingE20andE20manipulatingE20aE20simpleE20databaseE20ofE20booksE2eE20TheE20codeE20snippetsE20embeddedE20throughoutE20theE20documentE20areE20predominantlyE20gatheredE20orE20adaptedE20fromE20thisE20eE78ampleE2eE20AlthoughE20theE20documentE20focusesE20specificallyE20onE20describingE20theE20supportE20ofE20E44BMSE20APIsE20inE20theE20S60E20platformE2cE20itE20isE20mostlyE20applicableE20toE20otherE20SymbianE20OSE20devicesE20tooE2eX
qmarsZeditionQNx2X
qmarsZencodingQUxhttpE3aE2fE2fswE2enokiaE2ecomE2fencodingE2d1E2fpdfX
qmarsZlanguageQUxhttpE3aE2fE2fswE2enokiaE2ecomE2flanguageE2d1E2fenX
qmarsZrevisionQNx0X
qmarsZsizeQNx429733X
qmarsZtitleQSxS60E20PlatformE3aE20UsingE20E44BMSE20APIsE20v2E2e0X
qncZrightsQSxCopyrightE20Ea9E202004E2d2006E20NokiaE20CorporationE2eX
qncZsupersedesQUxhttpE3aE2fE2fswE2enokiaE2ecomE2fidE2fd8040e94E2d9f2fE2d46a5E2da03aE2dad17703f0a03E2fSymbianE5fOSE5fUsingE5fE44BMSE5fAPIsE5fv1E5f0E5fenE2epdfX
qwebZresolvesAsQUxhttpE3aE2fE2fforumE2enokiaE2ecomE2fdpE3furiE3dhttpE253AE252FE252FswE2enokiaE2ecomE252FidE252Fe0a66f34E2d092aE2d4a52E2d8003E2d6bbc3aa83c8fE252FS60E5fPlatformE5fUsingE5fE44BMSE5fAPIsE5fv2E5f0E5fenE2epdfX
qrdfZtypeQUqfnZE45E78cludedFromGeneralE4cistingsQ
qrdfZtypeQUqfnTypeZE44ocumentQ
qrdfZtypeQUqfnTypeZE52esourceQ
qrdfZtypeQUqmarsZManagedE52esourceQ
qrdfZtypeQUqwebZInformationE52esourceQ
qrdfZtypeQUqwebZE52esourceQ
qrdfZtypeQUqrdfsZE52esourceQ
qrdfsZseeAlsoQUxhttpE3aE2fE2fswE2enokiaE2ecomE2fidE2f5e8d013fE2dd81dE2d4089E2da34cE2d76858c3a0b58E2fS60E5fPlatformE5fE44BMSE5fE45E78ampleE5fv2E5f0E5fenE2ezipX



