SQLite Forum

sqlite3_exec stepping through multiple queries
Login
If you included a "sentinel query" between the two, it could help you identify the transition (as long you know the sentinel uses a different schema than the other queries). For example:

select * from mytable where gender = 'M'; select 'end-1' as EOQ; select * from mytable where gender = 'F'; select 'end-2' as EOQ;

Just a thought. One could just as easily issue two separate sqlite3_exec calls to know when one is done and another starts.