>>>>Bonnie,
>>>>
>>>>Here is the message, which confirms my original suggestion:
>>>>
>>>>Forum: Visual FoxPro Category: Coding, syntax & commands Title: Re: Scan...Endscan Thread #374171 Message #374418
>>>
>>>If there's index order set on the table foxpro has to use that index in SCAN to find next record regardless if there is or not WHILE !EOF(). The only difference WHILE !EOF() clause makes that SCAN starts processing from the current record in table not from the top.
>>
>>I guess, now I have to run couple of tests to confirm or deny the original statement. I'm in the middle of something, but hopefully will have time in the evening...
>
>I just realized that there also could be a difference in finding the first record. If SCAN implicitly uses GOTO TOP to find the first record than SCAN WHILE NOT EOF() could be faster because it doesn't have to do that.

Sergey,

Still tests are required, I just can not distract right now... But I believe, I tested this statement some time ago...