Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » UltraLite - C and C++ Programming » Application development » UltraLite C++ application development using embedded SQL


Quick start guide to UltraLite embedded SQL application development

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.

The development process for embedded SQL applications is as follows:

  1. Design your UltraLite database.

  2. Write your source code in an embedded SQL source file, which typically has extension .sqc.

    When you need data access in your source code, use the SQL statement you want to execute, prefixed by the EXEC SQL keywords. For example:

       int cost
       char pname[31];
    EXEC SQL SELECT price, prod_name
       INTO :cost, :pname
       FROM ULProduct
       WHERE prod_id= :pid;
  3. Preprocess the .sqc files.

    SQL Anywhere includes a SQL preprocessor (sqlpp), which reads the .sqc files and generates .cpp files. These files hold function calls to the UltraLite runtime library.

  4. Compile your .cpp files.

  5. Link the .cpp files.

    You must link the files with the UltraLite runtime library.

 See also