AnsweredAssumed Answered

Execute SQL: Searching

Question asked by tays01s on Jun 30, 2015
Latest reply on Aug 4, 2015 by tays01s


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?