Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » UltraLite - .NET Programming » UltraLite .NET 2.0 API reference » ULTable class » LookupForward methods

 

LookupForward(Int16) method

Moves forward through the table from the beginning, looking for a row that matches or is greater than a value or partial set of values in the current index.

Syntax
Visual Basic
Public Function LookupForward( _
   ByVal numColumns As Short _
) As Boolean
C#
public bool LookupForward(
   short numColumns
);
Parameters
  • numColumns   For composite indexes, the number of columns to use in the lookup. For example, if you have a three column index and you want to look up a value that matches based on the first column only, you should set the value for the first column, and then supply a value of 1.

Return value

True if successful, false otherwise.

Remarks

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 matches or is greater than the index value. On failure, (no rows greater than the value being looked for) the cursor position is after the last row ULDataReader.IsEOF).

Each search must be preceded by a call to LookupBegin.

See also