>>>>>Hi,
>>>>>
>>>>>LOCATE FOR Command Scans for records from Top to Bottom by defauld
>>>>>
>>>>>Is it possible to Locate records in reverse Direction. If yes, kindly Guide how to do this. If not, what's the alternative, if I have ample number of records.
>>>>>
>>>>>Regards
>>>>>Harsh
>>>>
>>>>It might be very slow this way.
>>>>INDEX ON 'A' TAG XATAG
>>>>SET ORDER TO XATAG DESCENDING
>>>>LOCATE FOR ...
>>>>
>>>>
>>>>What sequence do you really need? The sequence should be based on fields in the table, not record #. With such fields, you can SET ORDER TO sequence ASC/DESC, SEEK(), SCAN WHILE. Allowing you to process not only the entire set, but also subsets very fast.
>>>
>>>Personally I wonder why anyone still uses LOCATE at all. Pretty prehistoric.
>>
>>Except that since it's Rushmore-optimizable, very handy when you need to search based on multiple criteria.
>>
>
>I know it's Rushmore optimizable. My point was more that it is record based, not set based, which went out about 20 years ago.

You know I love SQL, but one of the strengths of VFP is that it offers both set-based and record-based processing. Each has its uses.

Tamar