your WHERE statement looks good. your parameters do not. You have 3 ? and 4 places defined.
; "" ; "" ; Class:K_ID ; 3.0 ; 1 )
; "" ; "" ; Class::K_ID; ;3.0; "1" )
You are correct.
WHERE \"class_id\" = ? and (\"GPA\" >? or \"Gifted\" = ?")
; "" ; "" ;
Class::K_ID ; 3.0 ; "1" )
So, we are trying to find a count of all the students in the class who are either gifted or have a high GPA.
I hope this makes it a bit clearer.
I can't seem to get this to work in FM with actual tables. What I'm trying to understand is how to structure an "Or" statement. Does it apply to the entire argument or just to what is inside the ( ). I need it to be isolated to just whats inside the ( ).
OK! you are using Aggregates, so may need the GROUP BY clause and/or the HAVING clause. I don't know the structure of your tables, so can't verify what query to use.