AnsweredAssumed Answered

Fieldvalue is incorrect after ExecuteSQL

Question asked by heinrichh on Jun 1, 2018
Latest reply on Jun 1, 2018 by beverly

Hi,

 

I am looking for the field value of the article table.

After ExecuteSQL(...) I get a wrong value of the field. Why?

 

Example:

Fieldvalue = 18,52 € after SQL I get

$price = 1.852 €

 

But if the Fieldvalue e.g. 1€, than I get with SQL the right value???!!!!

 

The field are Number-formatted. This problem is also there, if I read the SQL-Result as Number!

 

I dont know why, please help.

 

BR

Heinrich

Outcomes