Moves forward through the table from the beginning, looking for a row that exactly matches a value or set of values in the current index.
FindFirst( [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 FindFirst. For example, if 2 is passed, the first two columns are used for the FindFirst. If num_columns exceeds the number of columns indexed, all columns are used in FindFirst.
True if successful.
False if unsuccessful.
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.
To specify the value for which to search, set the column value for each column in the index. The cursor is left on the first row that exactly matches the index value. On failure the cursor position is after the last row (EOF).
NoteThis method requires that you first call FindBegin. |