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.