Re: [sqlite] SELECTing WHERE calculation > 0

2014-05-30 Thread jose isaias cabrera
"Edward Lau" wrote... Hi Jose: In SQL, aggregate function cannot be used in the WHERE clause. Use the HAVING clause instead. Try this: SELECT cust, ProjID, proj, A_No, bdate, CASE Xtra4 WHEN 'y' THEN vEmail ELSE 'noemail' END, sum(ProjFund), sum(

Re: [sqlite] SELECTing WHERE calculation > 0

2014-05-30 Thread jose isaias cabrera
"Richard Hipp" wrote... Do you want a HAVING clause? Thanks. Didn't know about this one. Now it works: SELECT cust, ProjID, proj, A_No, bdate, CASE Xtra4 WHEN 'y' THEN vEmail ELSE 'noemail' END, sum(ProjFund), sum(ProjFund)-sum(CASE Xtra4 WHEN 'y' T

Re: [sqlite] SELECTing WHERE calculation > 0

2014-05-29 Thread Edward Lau
27;) GROUP BY cust, ProjID, proj, A_No; HAVING sum(case Xtra4 when 'y' then invoice else 0 end) > 0 -Original Message- From: jose isaias cabrera To: General Discussion of SQLite Database Sent: Thu, May 29, 2014 2:18 pm Subject: [sqlite] SELECTing WHER

Re: [sqlite] SELECTing WHERE calculation > 0

2014-05-29 Thread Richard Hipp
Do you want a HAVING clause? On Thu, May 29, 2014 at 5:14 PM, jose isaias cabrera wrote: > > Greetings! > > I have this select, > > SELECT cust, > ProjID, > proj, > A_No, > bdate, > CASE Xtra4 WHEN 'y' THEN vEmail ELSE 'noemail' END, > sum(ProjFund), >

[sqlite] SELECTing WHERE calculation > 0

2014-05-29 Thread jose isaias cabrera
Greetings! I have this select, SELECT cust, ProjID, proj, A_No, bdate, CASE Xtra4 WHEN 'y' THEN vEmail ELSE 'noemail' END, sum(ProjFund), sum(ProjFund)-sum(CASE Xtra4 WHEN 'y' THEN invoice ELSE 0 END), sum(CASE Xtra4 WHEN 'y' THEN invoice ELSE 0 E