Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Looping through all the records in a table
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00020079
Message ID:
00020201
Views:
48
>>>I can't seem to get started with the program code to loop through (top to bottom) the records in a table. Can someone help?
>>
>>SCAN
>>...
>>ENDSCAN
>>are one option; another is
>>DO WHILE .NOT. EOF()
>>
>>ENDDO
>>
>>SCAN is preferred since it can be rushmore optimized and auto-skips to the next record.
>
>There is also the old For loop...
>GO TOP
>FOR i = 1 to RECCOUNT()
>...
>SKIP 1
>ENDFOR
>
>For is supposed to be faster than While but slower than Scan, but each one of these types of loops is most appropriate for different situations...

Well put! There are times when I actually use a Do While over a SCAN...
Steve Medvid
Systems Analyst

Environmental Resource Management
Previous
Reply
Map
View

Click here to load this message in the networking platform