You access data in fields by specifying one or more records that contain the target data. You can access a particular record by moving the record pointer using the GOTO command or you can specify a range or group of records using scope, FOR, or WHILE clauses in a command.

In This Section

Scope Clauses: Describes scope clauses that you can use to specify a range of records.

FOR Clauses: Describes FOR clauses that you can use to specify logical conditions to control the records you want to include.

WHILE Clauses: Describes WHILE clauses that you can use to specify logical conditions that control whether to continue performing operations on records.

Related Sections

Data Manipulation: Provides information on expressions that you can build to get full access to the power of manipulating data in Visual FoxPro.

Fields: Provides the definition of a field.

Records: Provides the definition of a record.