AnsweredAssumed Answered

ExecuteSQL help

Question asked by ezeitgeist on Nov 29, 2017
Latest reply on Dec 1, 2017 by ChrisJohnston

ExecuteSQL structure continues to confound me. I setup the following:

 

ExecuteSQL ( "SELECT Count (TestResponses::TestResponses_ID) FROM TestResponses WHERE Question_grade  = ? AND TestQuestionSection = ? AND TestResponses::Student_ID = ?" ; "" ; "" ; "+" ; 1 ; StudentTests::Student_ID )

 

It is meant to count records in the TestResponses table in which the TestResponses::Question_grade = "+", TestResponses::TestQuestionSection = "1", and TestResponses::Student_ID = StudentTests::Student_ID.

 

The ExecuteSQL calculation field is set in StudentTests table.

 

It returns a ?. What did I do wrong?

Outcomes