Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set order
Message
 
 
To
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:
01522152
Views:
42
Thanks Tore

Is there anything I can do with form interactive cursors as it seems to work of similar way of sql command
and all my data is based on this cursors rather than sql commands ?


Moises



>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