Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Storing a large negative number in a Property
Message
De
09/03/2006 14:36:56
Irv Adams
MSC Managed Care, Inc.
Floride, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Divers
Thread ID:
01102817
Message ID:
01102876
Vues:
20
>Irv,
>
>
>I was about to say the same as Borislav, I do no see that behaviour, I even tried setting a property to -214709043200000000000000000000 in the property sheet and it works just fine (set a textbox with controlsource = thisform.tag, which has that big value)
>
>
>[Update]Oops
>
>Is stored as Character, please gently disregard my message <g>
>
>[Update]OK
>I tried with a new property and it works well for -2147090432, the big number I posted before is converted to -2.1470904320000E+29, still no stars

This ended out to be my fault. The value was stored correctly in the property, but I extracted it for viewing and SQL storage using Transform(), and STR() without a second parm. Transform() has an issue with large negative numbers (from the help), and STR() limits to a length of 10 if you don't use a second parameter.

Thanks for your help,
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform