Slide 10.4: Palm OS databases (cont.)   Slide 10.6: Palm OS databases (cont.)   Home

Palm OS Databases (Cont.)

---

Working with Palm OS Databases and Records
The following APIs dealing with basic database functions:

• DmCreateDatabase( dbCard, DBName, CreatorID, DBType, false )
• DmFindDatabase( dbCard, "MyCoolestDB" )
• DmOpenDatabase( dbCard, dbID, mode )
• DmOpenDatabaseByTypeCreator( DBType, CreatorID, ... )
• DmCloseDatabase( db )
• DmOpenDatabaseInfo( db, &dbID, NULL, NULL, &dbCard, NULL )
• DmDatabaseInfo( dbCard, dbID, NULL, &attributes, NULL, ... )
• DmSetDatabaseInfo( dbCard, dbID, NULL, &attributes, ... )

The following APIs are more specific to DB information, error codes, etc.:

• DmDatabaseSize(dbCard, dbID, NULL, &totalBytes, &dataBytes)
• DmNumRecords( db )
• DmGetDatabaseLockState( db, NULL, NULL, &locks )
• DmDatabaseProtect(dbCard, dbID, (locks > 0) ? false : true)
• DmGetLastErr( )

The following APIs dealing with content of records:

• DmQueryRecord( db, index)
• DmGetRecord(db, index)
• DmNewRecord( db, &index, sizeof( DBRecordType ) )
• DmWrite( recP, 0, &dbRecord, sizeof( DBRecordType ) )
• DmRemoveRecord( db, curRec )

The following APIs dealing with attributes of records:

• DmReleaseRecord( db, index, true )
• DmRecordInfo( db, index, &attr, &uniqueID, NULL )
• DmSetRecordInfo( db, index, &attr, NULL )