FindPrevious(Int16) method

Continues a ULTable.FindLast() search by moving backward through the table from the current position, looking to see if the previous row exactly matches a value or partial set of values in the current index.

Syntax 
Visual Basic
Public Function FindPrevious( _
   ByVal numColumns As Short _
) As Boolean
C#
public bool FindPrevious(
   short numColumns
);
Parameters

  • numColumns   For composite indexes, the number of columns to use in the find. 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, then supply a value of 1.

Return value

True if successful, false otherwise.

Remarks

The cursor is left on the previous row if it exactly matches the index value. On failure, the cursor position is before the first row (ULDataReader.IsBOF).

FindPrevious behavior is undefined if the column values being searched for are modified during a row update.

See also
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1