2 Replies Latest reply on Jan 16, 2014 6:12 AM by philmodjunk

    SQL Syntax correction

    StephanToppinger

      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?