Locate Record Dialog Box
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.
- Scope
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.
- For
Displays the Expression Builder dialog box, in which you create the logical expression that every record must meet to be affected by the command.
- While
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.
- Locate
Carries out the command using the Scope, For, and While values.
See Also
Tasks
Reference
Browse Window
CONTINUE Command
Expression Builder Dialog Box
LOCATE Command
Scope Dialog Box
Record Manipulation Language