Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
I need a special kind of index
Message
De
06/04/2006 08:36:32
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
I need a special kind of index
Versions des environnements
Visual FoxPro:
VFP 7 SP1
Divers
Thread ID:
01110927
Message ID:
01110927
Vues:
49
The data I have is the following
   Date         Number of days
(MM/DD/YYYY)
------------------------------     
01/01/2006           150
01/05/2006           80
02/01/2006           10
I'd like it to to indexed so that the number of days is added to the date. This way I'll know just by looking at the first record (with that index) if some action has to be taken because the number of days since a given date has elapsed.

When browsing that data the result would be:
02/01/2006           10     Date + number of days is 02/11/2006
01/05/2006           80     Date + number of days is 03/26/2006
01/01/2006           150    Date + number of days is 05/31/2006
Easy way out of this?
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform