>I've seen a number of posts here about adding a WHILE NOT EOF() condition to a SCAN..ENDSCAN loop. I get the impression that this seems to make the loop process more quickly.
>
>I've always thought the WHILE NOT EOF() was redundant.
>
>Could someone please explain to me how including it speeds up the processing?
>
>Thanks.............Rich

Adding the WHILE clause makes the SCAN/ENDSCAN not reset the record pointer to the first record. If you want to process from the middle of a table to the end, use WHILE.