Fabio

INDEX ON "A" TAG myATag
SET ORDER TO myATag DESCENDING
LOCATE


I have try this solution, but:

a) when a index is active, VFP LOCATE use a scan/seek method,
and this is not the much best one than GO BOTTOM.

b) use a descending index have the
- a) limit
- i must build a index for do only this simple task

INDEX ON .T. TAG descTag DESCENDING

Use SET ORDER DESCENDING with other tags.


when a index is active ( with a) limit ) :

SET ORDER TO TAGNO() DESCENDING 
LOCATE
SET ORDER TO TAGNO()

can resolve the problem

Question:
VFP support this for set the RECNO() order:

SET ORDER TO 0

Why it not support this
( no error is fired, but recno() ascending is applied )?

SET ORDER TO 0 DESCENDING

Thanks Mike