Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Floating point and remote views
Message
From
21/07/2011 10:03:01
 
 
To
21/07/2011 09:44:53
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01518756
Message ID:
01518760
Views:
55
>I am hoping some of the serious math wonks will take pity on an old man who still finds long division challenging.
>
>I have SQL database tables that make heavy use of floating point numbers.
>
>In my remote view, I am pulling half a dozen of those numbers. The remote view defines them as data type 'B' ( of which I have not previous experience)
>
>I need to multiply those number together, then put the result in a field I created as part of the remote view ( casting a 0 as float )
>
>But in the watch window these values all show up as N , even though the values can look like 140333030.002033021000

One key point is that variables don't have the same range of data types as fields. So if you copy a float or double to a variable, Locals and Watch will show it as N.

Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform