float column -- Ivan ?

[George Parkinson]

seriously?
you're suggesting i have to use the format() function to read back a value i put into a float?
i must be missing something here...where can i find scale / precision info for float columns?
thanks,
george



________________________________
 From: Ivan Smahin <ivan_smahin at paradigmasoft.com>
To: Valentina Developers <valentina at lists.macserve.net> 
Sent: Friday, April 20, 2012 9:45:04 AM
Subject: Re: float column -- Ivan ?
 



On Apr 19, 2012, at 11:48 PM, George Parkinson wrote:

hi ruslan,
>i find virtually nothing on scale/precision in wiki...
>and even less in vstudio.
>exactly where can i find these settings?
>thanks,
>george
>
>
>
>
>
>
>
>________________________________
> From: Ruslan Zasukhin <ruslan_zasukhin at valentina-db.com>
>To: "valentina at lists.macserve.net" <valentina at lists.macserve.net> 
>Sent: Thursday, April 19, 2012 2:23:56 PM
>Subject: Re: float column -- Ivan ?
> 
>On 4/19/12 8:52 PM, "George Parkinson" <george at microtherapy.ca> wrote:
>
>Hi George,
>
>> hello all,
>> i have a float column (f) in table t.
>> some values do not read back as inserted.
>> 
>> for example:
>> INSERT INTO t (f) values (341.1) -->>  reads back as 341.10001
>> INSERT INTO t (f) values (341.2) -->> reads back as 341.20001
>> INSERT INTO t (f) values (341.3) -->> reads back as 341.29999
>> INSERT INTO t (f) values (341.4) -->> reads back as 341.39999
>> INSERT INTO t (f) values (341.5) -->> reads back as 341.50000
>> INSERT INTO t (f) values (341.6) -->> reads back as 341.60001
>> INSERT INTO t (f) values (341.7) -->> reads back as 341.70001
>> INSERT INTO t
 (f) values (341.8) -->> reads back as 341.79999
>> INSERT INTO t (f) values (341.9) -->> reads back as 341.89999
>> INSERT INTO t (f) values (341.10) -->> reads back as 341.10001
>> 
>> the question is: is this normal?
>
>FLOAT/DOUBLE columns have additional parameter decision/scale
>
>Check it ...easiest way using Valentina Studio and your db.
>
>
>-- 
>Best regards,
>
>Ruslan Zasukhin
>VP Engineering and New Technology
>Paradigma Software, Inc
>
>Valentina - Joining Worlds of Information
>http://www.paradigmasoft.com
>
>[I feel the need: the need for speed]
>
>
>_______________________________________________
>Valentina mailing list
>Valentina at lists.macserve.net
>http://lists.macserve.net/mailman/listinfo/valentina
>
>
>
Yes, should be more info. In short, both params defines how float/double should be converted into the string result whenever it needed.

Defaults are:
(15,6) for double
(6,5) for float

For example:

SELECT 'Float value:' | fld_float FROM t1
--
'Float value:     1.12345' -- for 1.12345



BTW, it could be better use Format() sql-function
http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:expr:funcs_string&s%5B%5D=format#format



-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20120420/74cd805f/attachment.html>