Visual FoxPro Scan command

FoxPro has an unusual type of loop specifically for processing data in tables. The Scan loop steps through the a recordset and executes the statements in the loop body for each record. Its simplest form is equivalent to a While loop:

This is however more flexible than a While loop because the Scan can accept a For clause which will select which records are to be processed. The loop statement below will only process those records where the cost field is greater than 1,000:

Case  | s Loops  |  For