2 Replies Latest reply on Nov 28, 2016 1:04 AM by InfoAuch

    FM15, subqueries are not working

    InfoAuch

      Hello,

       

      I need to retreive data using sub-queries but I am meeting an issue.

       

      Subqueries in ExecuteSql function are not working as specified in user manual (fm14_sql_reference.pdf).

       

      ExecuteSql("SELECT id, name FROM test WHERE id IN (4,5,6)"; ";"; ...) returns ? Same thing with a sub-query "SELECT id, name FROM test WHERE id IN (SELECT id_article FROM article WHERE...)"

       

      See file test.

       

      Any idea ? Thank you

       

      Tom.