Sqlite3 in C, running multiple queries

Question

I'm writing a C program and running multiple queries with sqlite. I'm not using sqlite3_exec() as you can't retrieve results without writing a callback function for it.

So I have source that looks something like this:

char * query = "CREATE TABLE 'items' (id int, icon int, name text); CREATE TABLE 'icons' (id int, image blob); CREATE TABLE 'playfields' (id int, name text);";
sqlite3_prepare_v2(dump_db_into,query,-1,&sqlstmt,0);
sqlite3_step(sqlstmt);

And of course, only the first query is executed. Do I need to run sqlite3_step() multiple times?

I'd rather avoid having to run these commands over and over if I have a large amount of queries

J V · Accepted Answer · 2012-02-06 23:19:45Z

4

Found in the references, my bad:

These routines only compile the first statement in zSql, so *pzTail is left pointing to what remains uncompiled.

answered Feb 6, 2012 at 23:19

J V

12.1k10 gold badges56 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sqlite3 in C, running multiple queries

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related