Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set order
Message
From
29/08/2011 14:55:10
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01522130
Message ID:
01522151
Views:
45
Yes, but as I wrote earlier; it's really a terrible idea. And if the date field is really a date field, you must use customer + dtoc(date,1) as index expression.

NB! I may have said it earlier: Avoid this solution, use separate index tags for the two fields instead, and use SQL syntax.

>Naomi
>
>Can I use + operator to create a compound index in interactive table creator ?
>
>I remember I did this a long time ago, not not exactly how.
>
>
>Moises
>
>
>
>
>
>>>How to I set order to more than one field ?
>>>
>>>For example: customer + date
>>>
>>>I remember this was possible in Dbase
>>
>>If you have a compound index tag for both fields, then just set order to this tag.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform