UltraLite Database User's Guide
Developing Applications for the Palm OS
On the Palm OS, it is important to distinguish between UltraLite databases and the Palm data store, which is sometimes called the Palm database. In this documentation, the term PDB means a Palm database and database refers to an UltraLite relational database. In addition to the Palm data store, Palm OS version 4.0 and later also support a virtual file system (VFS) on expansion cards.
UltraLite databases can be stored either in the Palm data store on the virtual file system on expansion cards. The way of specifying the storage depends on the interface used:
UltraLite for MobileVB To use the virtual file system, set the VFS On Palm parameter. See VFS On Palm parameter .
UltraLite C++ component, static C++ API, embedded SQL Call ULEnablePalmRecordDB or ULEnableFileDB at the beginning of your application. See ULEnablePalmRecordDB function and ULEnableFileDB function.
When using the Palm data store, UltraLite actually stores database information in multiple PDBs, whose names are constructed using the given creator ID. For example, a database created with a creator ID of ABCD causes the following files to be created:
ul_state_ABCD
ul_udb_ABCD
UltraLite uses the state PDB (ul_state_ABCD) to hold the current row on which the application is positioned for any open tables when the application exits. The state PDB allows UltraLite allows you to write your application so that when it is launched, users can resume where they left off.
SQL Anywhere Studio 9.0.2
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.