Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create index to sort Names ascending & Dates descending
Message
From
18/07/2006 15:06:00
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01137344
Message ID:
01137352
Views:
18
>I have a temporary table with user names and dates. User names are repeated with many dates for each user name. I need to print this table sorted by user name (ascending) with dates for each user (descending). I normally create another field and subtract the date fields from today's date to get a number that when sorted (ascending) will print the dates in descending order. Is there a simpler way to mix ascending and descending together?

with a string
INDEX ON UserName+bintoc({^9999/12/31}-userdate) ...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform