1 2 Previous Next 28 Replies Latest reply on Jan 30, 2014 2:14 PM by gdurniak

    Strange SQL behavior

    DanielShanahan

      These work:

      ExecuteSQL ( " SELECT SUM ( amount ) FROM money WHERE type = ? " ; "" ; "" ; "Expense" )

      ExecuteSQL ( " SELECT SUM ( amount ) FROM money WHERE type <> ? " ; "" ; "" ; "Expense" )

      ExecuteSQL ( " SELECT SUM ( amount ) FROM money WHERE type <> ? " ; "" ; "" ; "Donation" )

       

       

      But this does not:

      ExecuteSQL ( " SELECT SUM ( amount ) FROM money WHERE type = ? " ; "" ; "" ; "Donation" )

       

      Can anyone shed light on this? I'm perplexed!

        1 2 Previous Next