UltraLite Database User's Guide
Using UltraLite Static Interfaces
Overview
The basic features of the development process are common to all static interfaces. The following diagram summarizes the key features.
Create a reference database, which contains a superset of the tables to be included in your application. It may also contain representative data for your application. This reference database is needed only as part of the development process, and is not required by your final application.
Add the SQL statements into a special table in the reference database. The way this is accomplished is dependent on the interface you choose:
If you are using the C++ API or Java, these statements are added to your database using Sybase Central or a stored procedure.
If you are using embedded SQL, the SQL preprocessor adds the statements to the reference database for you.
Run the UltraLite generator, which produces source files that include code needed to execute your SQL statements, and code needed to define the database schema for your UltraLite application. This generated code includes function calls into the UltraLite runtime library.
Create application source files. If you are using embedded SQL, the SQL preprocessor reads your .sqc files and inserts the SQL statements into the reference database for you.
Compile your application source files together with the generated source files to produce your UltraLite application.