Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ALLTRIM in indexes
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00138923
Message ID:
00141179
Views:
34
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform