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

FindLast method Next Page

FindNext method

Moves forward through the table from the current position, looking for the next row that exactly matches a value or set of values in the current index.


FindNext( [ 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 FindNext. For example, if 2 is passed, the first two columns are used for the FindNext. If num_columns exceeds the number of columns indexed, all columns are used in FindNext.


True if successful.

False if unsuccessful (EOF).


The current index is that 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.

The cursor is left on the first row found that exactly matches the index value. On failure, the cursor position is after the last row (EOF).


This method requires that you first call FindFirst or FindLast.

See also