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

FindFirst method Next Page

FindLast method

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


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


num_columns    An optional parameter referring to the number of columns to be used in the FindLast. For example, if 2 is passed, the first two columns are used for the FindLast. If num_columns exceeds the number of columns indexed, all columns are used in FindLast.


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 for which you want to find the value. The cursor is left on the last row found that exactly matches the index value. On failure the cursor position is before the first row (BOF).


This method requires that you first call FindBegin.

See also