Ac2002: ImportXML() and decimal points?

[Guest]

Hi all,

importing numeric XML data with the Application object's ImportXML() method
(in Ac2002) into a column of data type "decimal" seems not to work: The XML
element
<amount>500.00</amount>
results in a database value of 50,000.00 instead of 500.00.

I suspect that this might have to do with my German Windows environment: the
local settings specify a comma as separator for decimal places (and a dot as
thousands separator, i.e. just the opposite of the English/American settings).

Nonetheless should the XML data be imported correctly, all the more since
the local decimal _comma_ ist not accepted by ImportXML().

Any ideas how to solve this import problem?

Thanks in advance

JotKa

 

[Guest]

I suspect that this might have to do with my German Windows environment: the

local settings specify a comma as separator for decimal places (and a dot as
thousands separator, i.e. just the opposite of the English/American settings).

Confirmed: When changing the local environment to decimal POINTS (and a
comma as thousands separator char), it works as expected.

Of course, I cannot have the users of our application force to change their
local settings, however, nor am I allowed to change the settings
programmatically.