Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Y2K and indexing on dates VFP 5.0
Message
De
10/01/2000 13:04:10
 
 
À
10/01/2000 12:55:15
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00315604
Message ID:
00315610
Vues:
22
>MyTable with a date field (8 spaces- i.e 01/10/00) won't index properly. I set order to Date and the 2000 entries appear at the top of the list. How can this be fixed?

Is it a date type field or a character field containing a date? Date fields index correctly. And even if you're using a date field, you may want to use DTOS(datefield) for the index, in case you need to concatenate something else to it.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform