Moves backward through the table from the beginning, looking for a row that matches or is less than a value or partial set of values in the current index.
Visual Basic Public Function LookupBackward( _ ByVal numColumns As Short _ ) As Boolean
C# public bool LookupBackward( short 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 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 that matches or is less than the index value. On failure, (no rows less than the value being looked for) the cursor position is before the first row (ULDataReader.IsBOF).
Each search must be preceded by a call to LookupBegin.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|