Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Finding the last item
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Finding the last item
Miscellaneous
Thread ID:
00839035
Message ID:
00839035
Views:
61
If I have a table fields= Card,detail# and and duplicates are allowed how do I find the most current since Seek locates the first one? For example if I have the following:
x3399 8002
x3399 8003
x3399 8004
x3399 8005 <--- I want this one since it's most current

I tried to reverse "index on card# +str(VAL(detail)*-1) TO m-index"
but detail still ends up in ascending order.
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."
Next
Reply
Map
View

Click here to load this message in the networking platform