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.

Syntax

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

Parameters

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.

Returns

True if successful.

False if unsuccessful.

Remarks

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).

Note

This method requires that you first call FindBegin.

See also