The right way to query sqlite is to use sqlite3_prepare() and sqlite3_bind_xxx() and then sqlite3_step(). How do you build complex queries of form
"SELECT * FROM parent WHERE id IN (SELECT parent_id FROM child_table1 WHERE child_param1=x AND child_param2=y INTERSECT SELECT parent_id FROM child_table2 WHERE child_param3=z);" Let's assume this query will be built in runtime dynamically, i.e. we don't know in compile time how many children attribute conditions will be given. BR, Denis Gorodetskiy _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users