InfoAuch

FM15, subqueries are not working

Discussion created by InfoAuch on Nov 24, 2016
Latest reply on Nov 28, 2016 by 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.

Attachments

Outcomes