Re: [sqlite] How to interleave calls to sqlite3_prepare_v2 and sqlite3_step?

On Thu, 2007-03-01 at 05:35 +0100, daan wrote: > I'm compiling a SQL statement (consisting of multiple statements separated > by semicolons) using sqlite3_prepare_v2 into a series of sqlite3_stmt > pointers, later to be executed with sqlite3_step(). > > A statement such as: > > DROP TABLE IF

[sqlite] How to interleave calls to sqlite3_prepare_v2 and sqlite3_step?

I'm compiling a SQL statement (consisting of multiple statements separated by semicolons) using sqlite3_prepare_v2 into a series of sqlite3_stmt pointers, later to be executed with sqlite3_step(). A statement such as: DROP TABLE IF EXISTS test; CREATE TABLE test (id INTEGER, name TEXT); is