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

SQL Anywhere 11.0.0 » UltraLite - M-Business Anywhere Programming » UltraLite for M-Business Anywhere API reference » ULTable class


findLastForColumns method

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

Boolean findLastForColumns( UInt16 numColumns )
  • 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 numColumns value of 1.


true if successful, false otherwise.


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 found that exactly matches the index value. On failure the cursor position is before the first row (isBOF).

Each search must be preceded by a call to the findBegin method.

See also