Searching rows

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.

Note

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.

 Example
 See also