Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why won't return a value with Decimal Places ??
Message
From
24/01/2003 04:27:23
Gerry Schmitz
GHS Automation Inc.
Calgary, Alberta, Canada
 
 
To
23/01/2003 23:33:36
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00744962
Message ID:
00744997
Views:
17
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform