AnsweredAssumed Answered

Strange SQL behavior

Question asked by DanielShanahan on Jan 28, 2014
Latest reply on Jan 30, 2014 by gdurniak

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!

Outcomes