Problem loading recordset from XML file
I have the next problem when I load a recorset from a XML file: A column
of the XML has a value with 10 decimals, but the recordset has a rounded
value with 2 decimals. By example, in XML file the value is 2550729.7199999997
and de recorset.fields().value is 2550729.27.
I ask in the VB debugger mode about yours values a reply:
?recordset.fields("column").value = 2550729.27
?recordset.fields("column").value = 2550729.7199999997
Where is the problem? It looks like the recorset doesn't operates with the
right precision. How can I get the numeric field in its right number of decimals?
Thanks a lot ! I'm waiting yours answers !!!!!