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

SQL Anywhere 10.0.1 » UltraLite - AppForge Programming » UltraLite for AppForge API Reference » ULTable class

LookupBegin method Next Page

LookupForward method

Moves forward through the table starting from the beginning, looking for the first row that matches or is greater than a value or set of values in the current index.


LookupForward( [num_columns As Long = 32767 ] ) As Boolean
Member of UltraLiteAFLib.ULTable


The current index is used to specify the sort order of the table. It is specified when your application calls the Open method. The default index is the primary key.

To specify the search value, set the column value for each column in the index. The cursor is left on the first row that matches or is greater than the index value. On failure (that is, if no rows are greater than the value for which it is searching), the cursor position is after the last row (EOF).


num_columns    For composite indexes, the number of columns to use in the lookup.


True if successful.

False if unsuccessful.

See also