Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index portion of Tag in reverse
Message
 
 
To
25/08/2010 19:58:01
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01478512
Message ID:
01478514
Views:
53
>How do I make just one of the elements of a tag sort in reverse. What about the same for SQL. I am trying to sort a report in reverse Date order, then Alphabetically (fwd) within those dates.
>
>Thanks, Randy

With SQL it's very easy

select * from myTable order by Date1 DESC, CharField

With Tag it's a bit more complex

index on bintoc(date(3000,1,1) - DateFld) + CharField Tag Reverse
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform