Using extended attributes with an UltraLite application

UltraLite databases do not support system tables, so no extended attributes can be defined in an UltraLite database. If you want to use extended attributes in an UltraLite application, follow these steps:

  1. Define extended attributes while you are connected to a consolidated SQL Anywhere database through an ODBC connection.

  2. Create the DataWindow objects that you need in your UltraLite application while connected to the consolidated SQL Anywhere database. The extended attributes are stored in the definitions of the DataWindow objects, which can be used with any database connection.

  3. Use the DataWindow objects created using SQL Anywhere in an application designed for UltraLite deployment.

This technique lets you take advantage of PocketBuilder extended attributes without the overhead of additional tables in the UltraLite database.