[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