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

InsertBegin method Next Page

LookupBackward method

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


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


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


True if successful.

False if unsuccessful.


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 value for which to search, set the column value for each column in the index. The cursor is left on the last row that matches or is less than the index value. On failure (that is, if no row is less than the value for which it is searching), the cursor position is before the first row (BOF).

See also