AnsweredAssumed Answered

Using ExecuteSQL to count records in Table with Group By

Question asked by jhollingsworth on Apr 20, 2018
Latest reply on Apr 21, 2018 by jhollingsworth

I have seen many people complain about ExecuteSQL with Group By speed or crashing and and i know that there are many solutions to the same problem in FM.  i am asking for help to come up with a solution to this simple query:

 

ExecuteSQL ( "select count(*) from Trees group by Plot, Site_id";"";"")

 

it seems to work in the data viewer but on the table

 

 

FM 14 pro advanced

thanks

Outcomes