AnsweredAssumed Answered

Execute SQL in Filemaker

Question asked by jurijn on Aug 7, 2015
Latest reply on Sep 18, 2015 by bertrand

Hey developers,


I used some SQL to get some data back from FM.

I have problems with the returned data, that means numbers contains decimal places. I dont want them so I wanted to use round (column, 0) function in a query (without success).


That is the query, that I used in executeSQL function inside a set variable script step:

..."SELECT worker_name, round( sum( revenue ), 0 ) FROM sales where worker_name IS NOT NULL group by worker_name"...


I could´t manage function to work. If I run executeSQL without round function in a query everything works fine.


Is that not supported in FM or is the query wrong? I am not quite sure that must I admit


Please share some your opinion and experience on that topic!