>>Hi All. I have been reading some threads about SCAN - ENDSCAN. Due to old habits I have used DO WHILE but am interested in the speed improvements that SCAN ENDSCAN appear to offer.
>>
>>Any gotchas to watch out for when converting DO WHILE loops to SCAN ENDSCAN? I did read Dragan's comment about nested SCAN's on the *same* file. Are there any others?
>
>Note that with SCAN, there is no guarantee that the records will be processed in any specific order. Sometimes this matters, usually it doesn't.
If the table scanned is sorted by an index are you saying that scan might not go in the sorted order?
Semper ubi sub ubi.