>>thnaks you.it is working faster than my codes. Buy i am unable to understand . I am using both commands for one work.
>>1.set filter to&&
>>2.do while .not. eof()
>>But the scan command is work for both work. Please explain me.
>>thanks
>
>SCAN FOR (condition)
>
>will process all records that fulfill the condition. That is, you don't need a filter. Also, you don't need a SKIP - that is implicit in the ENDSCAN.
However, the fact that it uses Rushmore Optimization doesn't necessarily mean that it is the fastest option. In my experience, the following should be faster:
lnValue = ...
set order to "KeyField"
scan while KeyField = lnValue
endscan
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)