Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Adding Indexes to VFP tables programmatically
Message
De
16/07/2002 20:20:15
 
 
À
16/07/2002 16:38:18
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00679363
Message ID:
00679428
Vues:
24
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
Fil
Voir

Click here to load this message in the networking platform