>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.

>
>>Nadya,
>>
>>FYI ... SCAN WHILE !EOF() is usually redundant.
>>
>>~~Bonnie
>>
>>>>hi all,
>>>>
>>>>How can I let the SCAN...ENDSCAN command to go through my table following the order of the index set?
>>>>
>>>>Thanks in advance,
>>>>Jimi
>>>

>>>set order to my order
>>>scan while !eof()
>>>...
>>>endscan

--sb--