Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why these two commands will give different results
Message
 
 
To
03/12/2006 08:44:53
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01174441
Message ID:
01174469
Views:
6
>>Hmmm, I checked that the length of the passed value is 4, though I only type three chars. I have MaxLenght property set to 4, but I do not see in the code where I add spaces at the end.
>>
>>I guess I have to fix my form's code just to make sure I always pass 4 chars and not less.
>
>I often have problems with extra spaces (from a TextBox) causing unexpected results, so I regularly apply alltrim().
>
>It looks as if you have the opposite problem; you might want to consider applying padr() to get a fixed size.

I did just in case, though I found that the code was already 4 characters. In any case, I switched to SUM vs. SELECT SUM and don't want to spend too much time again on this paradox.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform