Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing problem
Message
From
11/08/2005 07:04:18
 
 
To
11/08/2005 06:49:56
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
01040136
Message ID:
01040138
Views:
16
Set order to yourdate DESCENDING

>Hi there, so here is my problem:
>
>I have a dbf file with 2 date type fields, date1 and date2. How can I index the database on these 2 fields descending, when browse the datab the records to appeir descending .
>
>Ex.
>
>browse normal, I have arranged the records:
>
>date1
>record#1 01.01.2001
>record#2 01.02.2002
>record#3 01.01.2003
>record#4 01.01.2004
>
>date2
>record#5 02.01.2001
>record#6 02.02.2002
>record#7 02.02.2003
>record#8 02.02.2004
>
>After indexing, I need to have when I browse the following:
>
>date2
>record#1 02.02.2004
>date1
>record#2 01.01.2004
>date2
>record#3 02.02.2003
>date1
>record#4 01.01.2003
>date2
>record#5 02.02.2002
>date1
>record#6 01.02.2002
>date2
>record#7 02.01.2001
>date1
>record#8 01.01.2001
>
> |
>How is the ORDER formula to obtain this
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform