Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why not 1*(0.5-0.4-0.1) = 0?
Message
From
07/01/2005 11:24:35
 
 
To
06/01/2005 23:30:19
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Database:
MS SQL Server
Miscellaneous
Thread ID:
00974881
Message ID:
00975134
Views:
36
>>>A friend of mine asked this to me today. I said yes,0 with confidence and he said OK then go and put that in Excel as a formula.
>>>I thought it was an Excel bug but he turned and said it happens in SQL server with float datatype! I couldn't yet see that myself but trust his experience.
>>>Any idea and solution?
>>>TIA
>>>Cetin
>>
>>I always enjoy this scanerio.
>>
>>If computer can not compute, then why are they called computers?
>
>They can, and they do it much better than we can do using paper and pen. It's just the matter of infinite calculation... would you like to wait indefinitely for your computer to use up the known universe for memory just to add a few fractions?
>
>And even if the problem is solved for fractions, there's still the slight problem of algebraic irrational numbers, and then transcendental numbers... you wouldn't want to wait indefinitely for a correct result. You want a result with negligible error in a microsecond - and you're getting it.
>
>Now if programmers are not taught numeric maths... well, they should be.

I was just joking. I knew all this. :)
Greg Reichert
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform