Working with the UltraLite database interface

This section describes how to use the native UltraLite database interface with PocketBuilder. UltraLite is a deployment technology for SQL Anywhere databases that allows applications on small devices to use full-featured SQL to accomplish data storage, retrieval, and manipulation. UltraLite supports referential integrity, transaction processing, multi-table joins of all varieties, and most of the same datatypes, runtime functions, and SQL data manipulation features as SQL Anywhere. It provides an ultra-small footprint by generating a custom database engine for your application that includes only the features required by your application.

PocketBuilder supports UltraLite 9.x and UltraLite 10.x. The PocketBuilder UL9 (pkul920.dll) and UL10 interfaces (pkul1020.dll) use the UltraLite C++ Component API to implement communication with the database.