Searches for a record in the active table or view that matches specified conditions. Use this command when you want to search a table or view record-by-record on an indexed or unindexed field, or when you want to find more than one record in a table.
This dialog box appears when you choose the Locate command from the Go to Record Submenu.
- Allows you to specify the records on which Visual FoxPro is to act. ChooseAll, Next, Record, or Rest from the drop-down list. Choose a number from the spinner on the right when you select Next or Record from the Scope drop-down list.
- Displays the Expression Builder dialog box, in which you create the logical expression that every record must meet to be affected by the command.
- Displays the Expression Builder Dialog Box. The While expression specifies that the action affects records only as long as the logical expression is true. The first time the expression evaluates to false, the action ceases without considering remaining records.
- Carries out the command using the Scope, For, and While values.