Neo Anderson <neo_in_mat...@msn.com> wrote: > Is it possible to handle multiple results using sqlite3_step or any other API > calls? > > I want to execute the following SQL in one statement and want to get the two > resultsets. > > select 1 a; select 2 b;
No. In SQLite, each sqlite3_stmt* handle represents one resultset. If you want two separate resultsets, you need two separate statements. For this particular example, you can produce one row with two columns instead: select 1 a, 2 b; or two rows with one column: select 1 a union all select 2 a; Why do you want two resultsets? What is the actual problem you are trying to solve? -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users