Topic group

In addition to scrolling through rows, you can quickly find the row you want by searching for a value in a field you select. For example, you could quickly find a specific customer order by selecting the ORDER_NO field and typing the number of the order you want to find. You can search character, numeric, float, date, and memo fields.

To begin a search, click the Find Rows button, or choose Table|Find Rows.

The Find Rows dialog box provides options you can use to focus and speed up your search. The options you use depend on the search value you specify, the way information is organized in the table, how specific the search needs to be, and how much of the table you want to search.

Find What In your search text, you can specify any printable character, including spaces. The search string can be as long as the width of the search field. In general, the longer the search string, the greater the precision required. If you can’t find a match with the current search string, shorten it to increase your chances of finding a match.

Located in Field You can search for text in any field, whether or not it has been indexed. Searching is fastest when you search on an indexed field. Before you start your search, select the index you want to use as the master index.

You can also search non-indexed fields, such as memo fields. Doing so might be slower than an indexed search, particularly in tables with many rows.

Partial Length There is no requirement that the length of the search string be identical to the field value. This rule is checked by default.

Exact Length To be a match, the search string must appear in the field just as you type it.

Match Case Match Case requires that the field value match the search string exactly, including uppercase and lowercase letters.

Once you have selected the options you want, click Find. If a match is found, the row pointer moves to the matching row and the row appears highlighted. If no match is found, a message appears.

If you don’t find the match on the first try, shorten the search string or adjust other search options as needed and try again.