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