AnsweredAssumed Answered

ExecuteSQL ("SELECT COUNT (DISTINCT

Question asked by TorbenPoulsen on Jun 5, 2013
Latest reply on Feb 18, 2018 by tinhx7

Title

ExecuteSQL ("SELECT COUNT (DISTINCT

Post

     Hi

     I have a FM12 db where i am trying to use the execute SQL but it only returns ? to me.

     I have a filef called "udleveret til". This fiels is in a table called "District"

     What i am trying to do is count the number of unique entries in field "udleveret til". My calculation look like this:

     ExecuteSQL ("SELECT COUNT (DISTINCT udleveret til) FROM District" ; "" ; "")

     But i must do something wrong because it only returns a question mark.

     Any hep/idea would be appriciatted.

     TIA

     Torben

Outcomes