Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing character and date fields
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Indexing character and date fields
Divers
Thread ID:
00751736
Message ID:
00751736
Vues:
53
Hi All,

I would like to index on a character field, name_horse c (18), and a date field "serv_date.

The name_horse field should alphabatize a to z and then the serv_date field from the most current date to the oldest.

Amber Hanover 02/10/2003
Amber Hanover 02/09/2003
Amber Hanover 01/23/2003
Amber Hanover 12/21/2002
Babs 02/09/2003
Babs 02/02/2003
Babs 10/23/2002
Corinne Lobell 02/08/2003
Corinne Lobell 02/02/2003
Corinne Lobell 01/10/2003

This index alpha's the name okay, but the dates are oldest to newest
name+DTOS(date_serv)

If I declare the index when I open the table as:
"use healthvet order name_horse desc"
The dates are descending, but the names start with the "Z's".

This gives me an error message.
name+desc(DTOS(date_serv))

Is there a way to mix field types and have one ascending and the other descending?

TIA
Jim Harvey
jharvey@hanoverpa.com
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform