Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can ALLTRIM on an index field cause problems?
Message
De
07/03/2001 12:46:57
 
 
À
07/03/2001 10:29:49
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00482253
Message ID:
00482801
Vues:
9
Hi Doug,
Thanks for the response. Your examples prove my point. Unlike the original index expression that started this thread, you put a delimiter (either comma or space) between the two trimmed fields to avoid the confusion of two people, one named DAVID AVIS and the other named DAVI DAVIS.
-Dore

>Hi Dore.
>
>>Wouldn't trimming and concatentation in this way lead to potential errors.
>
>I only use this type of construct under very special circumstances, such as concatenating trim(LASTNAME) + "," + FIRSTNAME or trim(FIRSTNAME) + " " + LASTNAME.
>
>Doug
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform