Possible float / numerical bug

Antuan Johnson amjohnson09 at gmail.com
Thu Jun 11 03:29:57 CDT 2009


OK in vstudio pro build 3 2009,

lets say you set up a table lets call it TableA

lets create two fields

NumberA - Long Long (Type) (0)
NumberB - Float (Type) (0.00000)

Lets give NumberA (through the editor) a value of 100
and NumberB a vaule of 0.50 or as it shows in the editor  0.50000

now lets perform a query to multiply the two to demonstrate what happens:


Update TableA Set NumberA= NumberA * NumberB


 4:27:23 AM Number of affected rows: 1, query time: 0.000 sec


This returns 0 in NumberA when it should return 50? This also happens with
any other value used.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina/attachments/20090611/7e4ed9b1/attachment.html 


More information about the Valentina mailing list