AnsweredAssumed Answered

ExecuteSQL decimal separator issue?

Question asked by powell on May 2, 2012
Latest reply on Feb 12, 2015 by Ben

I'm developing in Italy, where decimal and thousand separators are inverted compared to the US usage, so decimal is comma while thousands is dot.

Using the ExecuteSQL function, pointing to the Filemaker database (not an external source), returns US separators.

 

So, for instance, I've got a number that is 10,5 and a calculation field, based on an ExecuteSQL function, where I have 2.6.

Trying to SUM the fields is a big mess! 2.6 is converted in 26... so I will have unwanted results.

 

Any idea on how to setup decimal separators on ExecuteSQL function?

Outcomes