>>>>I want to scan a table from bottom to top. Currently, I am using a while loop for that. Is there any faster way like scan?
>>>>
>>>>Thank you,
>>>>Ali
>>>
>>>No, not really. Do while and SCAN are equavalent in speed, AFAIK.
>>
>>I have not tested this for a few years but SCAN was 15% faster than using a DO WHILE loop.
>
>Interesting. I forgot that SCAN respects the order set on the table...
>
>Also why would we have a speed difference in WHILE LOOP vs. SCAN? It's doing the same, though we need to write more code. I guess internally it uses something different...

SELECT table1
DO WHILE NOT EOF()
DO SOMETHING && which changes workarea without putting it back.
select table1
IF NOT EOF()
SKIP
ENDIF
ENDDO

versus

SELECT table1
SCAN
DO SOMETHING && which changes workarea without putting it back.
ENDDO