Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SCAN ... ENDSCAN
Message
From
26/09/2001 12:12:53
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00560821
Message ID:
00561069
Views:
32
>I prefer DO WHILE because it is more flexible.

I only meant that I typically don't use DO WHILE in the particular case of scanning through a table. I'll use it wherever else it may be appropriate.

~~Bonnie


>Yep, I agree with you. And I even ran a test (thinking maybe I have been wrong for 10 years about how SCAN/ENDSCAN works), that proved it correct. Yes, it ran a bit slower with an index set (as one would expect it to). But there was no change at all whether WHILE !EOF() was used or not on the indexed scan. I even tried DO WHILE !EOF() (which I never use, but wanted to test anyway).
>


>I prefer DO WHILE because it is more flexible.
>0.02
>JLK

Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform