UltraLite Database User's Guide
  Welcome to UltraLite
    Developing UltraLite applications

Developing applications with UltraLite components

To develop an application using an UltraLite component you follow the following basic sequence of steps.

1. Design your database.

   A database schema is the database definition, including all tables, indexes, and so on. You create a database schema using the UltraLite Schema Painter or writing an XML file. Users of SQL Anywhere Studio can generate an UltraLite database schema from an Adaptive Server Anywhere database.

   UltraLite holds the database schema in a schema file. The UltraLite components use the information in this file to create a database when an application is first run.

   For more information on the UltraLite Schema Painter, see The UltraLite Schema Painter.

   For more information on the UltraLite utility ulinit, see UltraLite initialization utility.

2. Set up your development environment.

   In each component, you are required to develop your application on a specific development platform, and to deploy to a specific target device. To achieve this end, you need to set up your development environment in tandem with the target environment. Tutorials in the companion books show you how you can accomplish this setup.

   For more information on creating a project architecture for UltraLite ActiveX, see Adding the UltraLite component to the design environment.

   For more information on creating a project architecture for UltraLite for MobileVB, see the tutorial Lesson 1: Create a project architecture.

   For more information on creating a project architecture for Native UltraLite for Java, see Understanding UltraLite Development.

3. Write your application code.

   Create forms for your application and write code that includes:

   • Code to create, open and connect to a database

   • Code to access and modify data

   • Code for synchronization, if required for your application.

4. Deploy your application to the device.

   You can run the application in the development environment to confirm functionality, and you can configure application settings or synchronize your data to an enterprise database.

Each of these processes is outlined in detail in each interface book.