Hi Cetin,
Cetin, with SELECT ... ORDER BY ..., you build a virtual filtered index.
-----
Ok, with this constrain:
I want found the last record for a specific condition, using only the
data on original table ( no index, no duplex of any data ).
On VFP exists only two solution:
SET FILTER condition
GO BOTTOM
IF !BOF()
ENDIF
and
GO BOTTOM
DO WHILE IIF(BOF() OR condition,.F.,.T.)
SKIP -1
ENDDO
IF !BOF()
ENDIF
Fabio