AnsweredAssumed Answered

Execute SQL Group By

Question asked by philmcgeehan on Oct 29, 2014
Latest reply on Oct 29, 2014 by philmodjunk

Title

Execute SQL Group By

Post

Hello

I'd like to get a list returned with a calculated date field and a summary field using SQL.

So far I can get the dates on their own using this ExecuteSQL command:

                                                                 
ExecuteSQL ( "
                   SELECT \"c_MonthYear\"
                   FROM \"WeeklyWork_DASH\"
                   GROUP BY \"c_MonthYear\"
               " ; ",  "; "" )
               

2014-01-01
               2014-02-01
               2014-03-01
               2014-04-01
               2014-05-01
               ...

               

 

 

 

 

 

But when I try to add a summary field as well I get a "?" returned.

                                                                 
ExecuteSQL ( "
                   SELECT \"c_MonthYear\", \"s_DashUnits\"
                   FROM \"WeeklyWork_DASH\"
                   GROUP BY \"c_MonthYear\"
               " ; ",  "; "" )
?                    

 

 

 

 

Also, If I just try to get the s_DashUnits I also get a "?"

Hosted on FMS13
The majority of my users have FMP13, but a couple have FMP12A.

Does anybody know if I'll be able to get this to work... and how to?

Thanks

Outcomes