Continues a findFirst search by moving forward through the table from the current position, looking to see if the next row exactly matches a value or partial set of values in the current index.
Boolean findNextForColumns( 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.
The cursor is left on the next row if it exactly matches the index value. On failure the cursor position is after the last row (isEOF).
The findNext method behavior is undefined if the column values being searched for are modified during a row update.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|