2 Replies Latest reply on Jun 5, 2013 9:28 AM by TorbenPoulsen

    ExecuteSQL ("SELECT COUNT (DISTINCT

    TorbenPoulsen

      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