4
static int callback(void *NotUsed, int argc, char **argv, char **azColName){
7
printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
18
const char *commands[] = {
19
"CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100));",
20
"INSERT INTO t1 VALUES(1,13153,'thirteen thousand one hundred fifty three');",
21
"INSERT INTO t1 VALUES(1,987,'some other number');",
22
"SELECT count(*) FROM t1;",
23
"SELECT a, b, c FROM t1;",
27
rc = sqlite3_open(":memory:", &db);
29
fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
33
for (i = 0; commands[i]; i++) {
34
rc = sqlite3_exec(db, commands[i], callback, 0, &zErrMsg);
36
fprintf(stderr, "SQL error on %d: %s\n", i, zErrMsg);
37
sqlite3_free(zErrMsg);