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!

Thanks!

Outcomes