Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
LOCATING backwards
Message
From
27/10/2003 05:02:31
 
 
To
26/10/2003 08:29:47
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00842157
Message ID:
00842827
Views:
23
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()
  * found
ENDIF
and
GO BOTTOM
DO WHILE IIF(BOF() OR condition,.F.,.T.)
 SKIP -1 
ENDDO
IF !BOF()
  * found
ENDIF
Fabio
Previous
Reply
Map
View

Click here to load this message in the networking platform