Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why won't return a value with Decimal Places ??
Message
De
24/01/2003 04:27:23
Gerry Schmitz
GHS Automation Inc.
Calgary, Alberta, Canada
 
 
À
23/01/2003 23:33:36
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00744962
Message ID:
00744997
Vues:
21
>Select IIF(Far=.F.,Far2,0.00) as Far2 From Table1
>
>My Question , Why the Far2 is return 11 instead of -10.62 ??

Try this:
Select IIF( Far=.F., Far2, 00000.00 ) as Far2 From Table1
VFP used 0.00 (ie. a constant) to define Far2 in the SELECT as [4,2] ... though it did do a good job of jamming -11 into one digit.

This is one example of how VFP can corrupt numeric table data. I have also seen floating point numbers in fixed numeric fields.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform