Find a specific row in the current rowset or table by specifying a value for one of the columns (fields) of the target row. If a match is found, the row pointer moves to the found row.

Dialog box options

 

Find What

Type the value you expect to find in that field of the target row. You can specify any printable character, including spaces. For example, you could search for rows where the LastName field equals Johnson.

For text and memo fields, you do not have to enter the precise value for which you are searching. You can enter the beginning of a phrase, such as Bank, to find all rows beginning with the word Bank.

To search for a value stored in another field, a memory variable, or an expression, use parentheses. dBASE Plus searches the field specified in Located In Field for the value that the expression returns.

Field names dBASE Plus searches for rows where the selected field matches the value of another field in the same row. For example, you could search for rows where the YTD_Sales field equals the Ord_Rev field by selecting YTD_Sales in the Located in Field list, and specifying (Ord_Rev) in the Find What text box.

Memory variables dBASE Plus searches for rows where the selected field matches the value in the memory variable. For example, you could search for rows where the YTD_Sales field equals the value of the TotSales memory variable by selecting YTD_Sales in the Located in Field list, and specifying (TotSales) in the Find What text box.

Expressions dBASE Plus searches for rows where the selected field matches the value that the expression returns. For example, you could search for rows where the Sell_Price field equals nine times the quantity by selecting Sell_Price in the Located in Field list, and specifying (QTY*9) in the Find What text box.

Located In Field

Select one of the rowset’s fields (columns).

Search Rules

Click a radio button to choose either:

Partial Length The search string will be found within larger strings.

Exact Length The search string must match exactly (such as a whole word).

Match Case The case of the search string must be matched.

How to get there: In Table Run mode, choose Table|Find Rows.