UltraLite has different modes of operation for working with data. You can use two of these modes, find and lookup, for searching. The ULTable object has methods corresponding to these modes for locating particular rows in a table.
The columns you search with Find and Lookup methods must be in the index that is used to open the table.
Find methods Move to the first row that exactly matches specified search values, under the sort order specified when the ULTable object was opened. If the search values cannot be found, the application is positioned before the first or after the last row.
Lookup methods Move to the first row that matches or is greater than a specified search value, under the sort order specified when the ULTable object was opened.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|