Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why these two commands will give different results
Message
 
 
À
03/12/2006 08:44:53
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01174441
Message ID:
01174469
Vues:
7
>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform