AnsweredAssumed Answered

SQL Syntax correction

Question asked by StephanToppinger on Jan 15, 2014
Latest reply on Jan 16, 2014 by philmodjunk

Title

SQL Syntax correction

Post

     Hi! Can somebody help me out with this sql query?

     The result is a quotaion mark whatever I do :(

      

     ExecuteSQL("SELECT sum(t.QtyIN) FROM TransactionLog AS t JOIN Transactions AS r on t._fkTransactionID = r.__pkTransactionID WHERE r.TransactionDate < ?"; ""; ""; Globals::StatDateEnd)

      

     if I simplify it like this it works (but no use to me):

     ExecuteSQL("SELECT sum(t.QtyIN) FROM TransactionLog AS t "; ""; ""; "")

      

     ideas?

Outcomes