Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index portion of Tag in reverse
Message
 
 
À
25/08/2010 19:58:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
01478512
Message ID:
01478514
Vues:
52
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform