4 Replies Latest reply: Mar 20, 2013 7:25 AM by Heri Zhang RSS

    Number Format Error - Decimal / Thousand Separator problem?

      Hi there,


      I found number format error in my file.

      Data in database (format numeric) : 10000.00000, 150.00000, 70.00000  <-- '." is decimal format


      I'd set thousand and decimal separator format on edit script.

      SET ThousandSep=',';

      SET DecimalSep='.';


      After reload I get wrong number.

      10000.00000 should be 10.000, but the number become

      150.00000 should be 105, but the number become 15.000.000

      70.00000 should be 70, but the number become 7.000.000


      how to solve this error? This is because the separator problem?

      Thanks before.