Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement