Data Conversion Problem while importing XML files

Farukca

Hi,

I have problem on importing XML files.
The price data is like <Price>250</Price> in the XML file.

I am using this code to read from XML,

SalesLine.Amount := XMLLineNode.selectNodes('Price').item(0).text;

I can read it as a text data from the XML file.
But I can't convert it to decimal.

It returns an error like "Decimal := Text"

Any Help ?

Tommy_Schou

Farukca wrote:

Hi,

I have problem on importing XML files.
The price data is like <Price>250</Price> in the XML file.

I am using this code to read from XML,

SalesLine.Amount := XMLLineNode.selectNodes('Price').item(0).text;

I can read it as a text data from the XML file.
But I can't convert it to decimal.

It returns an error like "Decimal := Text"

Any Help ?

You need to use the evaluate function.. your code should be:

evaluate(SalesLine.Amount,XMLLineNode.selectNodes('Price').item(0).text);