Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ALLTRIM in indexes
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00138923
Message ID:
00141179
Vues:
35
>>You are wasting cpu cycels because VFP pads the field back out to be a constant length when you use ALLTRIM(). SET EXACT OFF and "Name " = "Name" will be equal.
>
>Interesting! I assume the "constant length" is the original length of the field? What about in an expression like AllTrim(first) + AllTrim(second)?

Suppose first is 'Alan' and second is 'Popow', and the fields are each 15 characters making the contents actually 'Alan' with 11 spaces and 'Popow' with 10 spaces. Your expression will create an index to 'AlanPopow' followed by 21 spaces. In other words, it will concatenate, but then pad out to the total size of the 2 fields.

Alan
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform