VFP Tutorial - Scan ... EndScan loop

The scan loop is unique to FoxPro. It processes records in a table and executes the commands within the loop once for every record in the current work area:

* The staff table holds managers and employees
Use Staff In 0

* Modify salaries and bonuses
Scan
   If Title = 'manager'
     * More money for managers
     Replace Salary With Salary * 1.10
     Replace Bonus With 10000
   Else
     * No rise or bonus for the other employees
     Replace Bonus With 0
   EndIf
EndScan

The code in this example will modify every record in the Staff table and reward the managers.

Notes

This example shows how one control structure can be embedded within another. The If structure is executed once for every record in the table.

Back to FoxPro program control.


Introduction | Environment | Project | Tables | Forms | Navigation | Executable

MS Access technical tips

Visual FoxPro technical tips

General Tips

 

More tips from Alvechurch Data

Visual FoxPro Tutorial - The Goto statement

The truth about the FoxPro Goto statement

Read More

Visual FoxPro Tutorial - If ... Else ... EndIf

Using If EndIf to control program flow in Visual FoxPro

Read More

Visual FoxPro Tutorial - Navigation

Navigating between records in Visual FoxPro

Read More

Visual FoxPro Tutorial - Variables

Using variables in Visual FoxPro

Read More

Visual FoxPro Tutorial - Program control

Syntax for program control structures in Visual FOxPro

Read More