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?