General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only