2 Replies Latest reply on Nov 18, 2014 8:33 AM by WF7A

    ExecuteSQL calc tweak, please

    WF7A

      Title

      ExecuteSQL calc tweak, please

      Post

      Hallo:

      What I'm trying to do is build a calc to count how many instances of the color, red (in the Value field), occur in a found set when the Phase (field) is equal to "III" (three i's, as in Roman numeral III).

      I have this so far but it's not working:

       

      ExecuteSQL ( "
        SELECT COUNT (Phase__lxt, Value__lxt)
        FROM Main
        WHERE Phase__lxt = 'III' and Value__lxt = 'Red'
         " ; ": " ; ""
      )


      I'm looking at Page 26 of the FM 13 SQL Reference Guide to try to discern how to do this but my brain is kaput. TIA for your help!