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.