Contents Index FindBegin method FindLast method

UltraLite ActiveX User's Guide
  UltraLite ActiveX API Reference
    ULTable class

FindFirst method


Prototype 

FindFirst( [num_columns As Long = 32767] ) As Boolean
Member of UltraliteActiveX.ULTable

Description 

Move forwards through the table from the beginning, looking for a row that exactly matches a value or set of values in the current index.

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 to search for, 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).

Note : Requires that FindBegin be called prior to using this method.

Parameters 

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.

Returns 

True if successful.

False if unsuccessful.


Contents Index FindBegin method FindLast method