Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I saw that you got your answer from Gordon, but I just wanted to warn you to be very careful when looking at something like Alltrim() in an index. Any function that can create ragged length indices may jump up and bite you later. VFP will only use fixed length indices, so if you use Alltrim() for example, Fox will end up padding to the length of the field and you'll have wasted your time. If you concatenate fields in an index that have been trimmed, then you will likely end up with a dog's breakfast. When you later try to do a seek, you may fool yourself and not get the results you expect.
Alan
>Thank you for your response but that does not address using an expression as the index, only the field name. I need to know if it is possible to add something like ALLTRIM(company_name) as an index to a table. If the INDEX command is the only way to add indexes, please explain how to use an expression instead of just the field name.
>
>Thank you
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