Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 17 » UltraLite - C++ Programming » Application development » UltraLite C++ application development

Data creation and modification in UltraLite C++ using the ULTable class

UltraLite applications can access table data by executing SQL statements or using the ULTable class.

The following tasks can be performed using the ULTable class:

  • Scrolling through the rows of a table.

  • Accessing the values of the current row.

  • Using find and lookup methods to locate rows in a table.

  • Inserting, deleting, and updating rows.

    Caution

    Do not update the primary key of a row. Delete the row and add a new row instead.


In this section:
    Row navigation in UltraLite C++
    The UltraLite C++ API provides you with several methods to navigate a table to perform a wide range of navigation tasks.
    UltraLite modes
    The UltraLite mode determines how values in the buffer are used.
    Row insertions in UltraLite C++
    The steps to insert a row are very similar to those for updating rows, except that there is no need to locate a row in the table before carrying out the insert operation.
    Updating rows
    Use the Update method to update a row in a table.
    Find and lookup modes for searching rows
    UltraLite has different modes of operation for working with data. You can use two of these modes, find and lookup, for searching. The ULTable object has methods corresponding to these modes for locating particular rows in a table.
    Access to values in the current row
    Use the ULTable object to manage the column values in a row.
    Row deletions in UltraLite C++
    The steps to delete a row are simpler than to insert or update rows. There is no delete mode corresponding to the insert or update modes.
Related Information
Data creation and modification in UltraLite C++ using SQL statements