General information
Category:
Coding, syntax & commands
>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only