UltraLite C++ application development using Embedded SQL

When developing Embedded SQL applications, you mix SQL statements with standard C or C++ source code. To develop Embedded SQL applications you should be familiar with the C or C++ programming language.

Embedded SQL is an environment that is a combination of C/C++ program code and pseudo-code.

The SQL Communications Area (SQLCA) is an area of memory that is used for communicating statistics and errors from the application to the database and back to the application. The SQLCA is used as a handle for the application-to-database communication link.

To connect to an UltraLite database from an Embedded SQL application, include the EXEC SQL CONNECT statement in your code after initializing the SQLCA.

Embedded SQL applications use host variables to communicate values to and from the database. Host variables are C variables that are identified to the SQL preprocessor in a declaration section.

Fetching data in Embedded SQL is done using the SELECT statement.

User authentication can be controlled using the ULGrantConnectTo and ULRevokeConnectFrom methods.

You can encrypt or obfuscate your UltraLite database using UltraLite Embedded SQL.

Synchronization is a key feature of many UltraLite applications. Members of the structures in the Embedded SQL API are similar to the UltraLite C++ API.

Building an Embedded SQL application requires knowledge of several configuration settings.