[2263] XML dump of DOUBLE rounds values

Stan Busk maxprog at mac.com
Tue Mar 27 04:32:58 CDT 2007


Hi,

Why don't you give us a way to set decimals number? I just need 2,  
sometimes 3 depending on currency.
Something like: SQLExecute( "SET PROPERTY XMLDump_DoublePrecision TO  
2" )

>     buff = "10149.2500036346345676547567567785678"
>                        ^^^^^^^^^^^^^^^^^^^^^^^^^^^ unexpected trail.

or (following my previous message) add a new type similar to mySQL  
'DECIMAL' type. That type allows you to set precision and scale:

"When declaring a DECIMAL or NUMERIC column, the precision and scale  
can be (and usually is) specified; for example:

salary DECIMAL(5,2)
In this example, 5 is the precision and 2 is the scale. The precision  
represents the number of significant digits that are stored for  
values, and the scale represents the number of digits that can be  
stored following the decimal point. If the scale is 0, DECIMAL and  
NUMERIC values contain no decimal point or fractional part."

stan


More information about the Valentina mailing list