Skip to main content

Hi All,


When using getDBValue with a value like 12.456 it will return the value with a (comma) , instead of (dot). This issue is only in the FSM iOS app.

Example:
 

var partIdTemp = "12.342";
var partIdDbResult = getDBValue(stringFormat("select part_id from part where part_id = '{0}'",partIdTemp));

Incorrect Result: 12,342 (comma)
Expected Result: 12.342 (dot)

Hi drooij

 

Can you provide more details? I tested on ios mobile. it works for me.


Thank you

Hi @drooij 

getDBValue method will return number values according to the locale. What is the locale set on your iOS device?

Many regions around the world use a comma as the decimal separator instead of a dot. Here are some key areas:

Europe

  • Countries that use a decimal comma:
    • Spain
    • France
    • Norway
    • Czech Republic
    • Denmark
    • Germany
    • Italy
    • Sweden
    • Finland
    • Netherlands

South America

  • Countries that use a decimal comma:
    • Argentina
    • Brazil
    • Chile
    • Colombia
    • Uruguay
    • Venezuela

Africa

  • Some countries, such as:
    • Zimbabwe
    • South Africa
    • Cameroon, also use a decimal comma.

Asia

  • Countries that use a decimal comma:
    • Indonesia
    • Mongolia

In contrast, countries like the United States, Canada, the United Kingdom, and many parts of Asia typically use a dot as the decimal separator.

 

Cheers!

Reply


Terms & ConditionsCookie settings