Skip to main content
Question

FSM Mobile (iOS) - getDBValue returns value with (comma) , instead of (dot) .

  • September 19, 2024
  • 2 replies
  • 28 views

Forum|alt.badge.img+9
  • Sidekick (Customer)
  • 48 replies

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)

2 replies

shalikakk
Hero (Employee)
Forum|alt.badge.img+7
  • Hero (Employee)
  • 37 replies
  • September 19, 2024

Hi drooij

 

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


Thank you


Shneor Cheshin
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • 1172 replies
  • September 19, 2024

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings