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?