SQLite Forum

Feature request: SQLITE_PREPARE_MULTISTMT
Login
What exactly happens when you call `sqlite3_step`? Does it just step through the statements one-by-one? What does it return after each one? `SQLITE_DONE`? If so, how do you know when the last statement is done? If you get an error, how do you know which particular statement failed?

Given all the constraints you mentioned (and others), this doesn't seem like a very useful feature to me. Note that you can already effectively execute multiple SELECTs with the constraints you mentioned simply by joining them together with UNION ALL.

It kind of sounds like you'd want something more akin to `sqlite3_exec`, just with more bells and whistles to account for multiple statements.