General information
Category:
Coding, syntax & commands
>>>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only