Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
I need a special kind of index
Message
From
06/04/2006 08:45:40
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
Miscellaneous
Thread ID:
01110927
Message ID:
01110938
Views:
10
>>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?
>
>INDEX ON DTOS(Date+NumberOfDays) TAG ....
>
Thank you Borislav.
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Previous
Reply
Map
View

Click here to load this message in the networking platform