Execute SQL: Searching
I have a simple query: ExecuteSQL("SELECT Na FROM Reqs_EN WHERE Age_threshold>?;Sex=?;Std=?";"";"";IO 2::Age;IO 2::Sex;IO 2::Std_EN)
The above is evaluated from TO 'IO 2'.
Na and Age fields are 'numbers', Sex and Std fields are 'text'. The IO 2::calc field is 'number' and the layout set to decimal though some answers could be text.
Unfortunately the answer is always '?' unless I reduce criteria to 'Sex', in which case the calc returns '57', a value that has nothing to do with the Na field I wanted searched.
Anything I should search for?