SQLite Forum

multiple queries
Login
The CLI evaluates multiple selects e.g. select * from table1;select * from table2;

sqlite3_prepare does not complain when the sql statement contains multiple selects.

When I invoke sqlite3_step, it has the first of the multiple select statements.

How do I move to the second & subsequent statements? i.e What API do I call?