Partager via


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

How to: Add Records to Tables

Reference

Browse Window

CONTINUE Command

Expression Builder Dialog Box

LOCATE Command

Scope Dialog Box

Record Manipulation Language

Other Resources

Dialog Boxes (Visual FoxPro)

Working with Records