How to work with decimal format in SQL: Set command if comma is used as decimal separator

Scenario:

When you’re trying to set a field through B1UP macro, sometimes depending on the region, the field value is either wrong or you get an error that the format of the value is not correct. This happens usually in regions where a comma is used as the decimal separator.

Solution:

In the macro, try to use Set(); with the SQL_INVARIANT: -functionality.

In this example, the bolded part can be any calculation or decimal value:

So instead of using SQL:
Set($[$29.0.0]|SQL:SELECT 1.15);

You can use SQL_INVARIANT:
Set($[$29.0.0]|SQL_INVARIANT:SELECT 1.15)

SQL invariant is used to ensure that decimal numbers are returned in the correct format depending on your system and region.

You can see more info in the manual:

https://manual.boyum-it.com/B1UP/index.html?command-set.html