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 using Embedded SQL

Data fetching

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

There are two cases that can be returned:

  1. The SELECT statement returns no rows or returns exactly one row.

  2. The SELECT statement returns multiple rows.


In this section:
    Single row fetching
    A single row query retrieves at most one row from the database.
    Multiple row fetching
    You use a cursor to retrieve rows from a query that has multiple rows in the result set. A cursor is a handle or an identifier for the SQL query result set and a position within that result set.