Create SQLite3 tables with C, but got an empty database file

Question

This is my code:

#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <sqlite3.h>

#define DBFILE "./userinfo.db" //It's empty file

int main(int argc, char *argv[])
{
    int retval;
    sqlite3_stmt *stmt;
    sqlite3 *handle;

    retval = sqlite3_open(DBFILE, &handle);
    if(retval)
    {
        perror("sqlite3_open");
        exit(-1);
    }
    printf("Connection successful...\n");
    char create_table[] = "CREATE TABLE IF NOT EXISTS"
    "users(uname TEXT PRIMARY KEY, pass TEXT NOT NULL)";

    retval = sqlite3_exec(handle, create_table, 0, 0, 0);
    if (retval)
    {
        perror("sqlite3_exec");
        exit(-1);
    }
    sqlite3_close(handle);
    return 0;
}

I compiled it and run it without any errors.

Before I run it, the database file userinfo.db is an empty file

after I run it, I got a empty database file again.

Why? table didn't be saved?

char create_table[] = "CREATE TABLE IF NOT EXISTS" "users(uname TEXT PRIMARY KEY, pass TEXT NOT NULL)"; shouldn't this be just one string? — Ionut Hulub
– Ionut Hulub, Commented Oct 17, 2012 at 1:39
You need a space between EXISTS and users, but no clue why there's no error. — ergosys
– ergosys, Commented Oct 17, 2012 at 1:44
@IonutHulub Two string literals with only whitespace between them gets automatically concatenated as a single string literal. — Some programmer dude
– Some programmer dude, Commented Oct 17, 2012 at 7:02

CL. · Accepted Answer · 2012-10-17 08:59:24Z

2

I get:

$ testprogram
Connection successful...
sqlite3_exec: No such file or directory

or, when the file already exists:

$ testprogram
Connection successful...
sqlite3_exec: Success

The reason is that the sqlite3_* functions do not set errno, which is the error code output by perror.

To output SQLite error messages, use sqlite3_errmsg:

fprintf(stderr, "sqlite3_exec: %s\n", sqlite3_errmsg(handle));

With that, I get:

$ testprogram
Connection successful...
sqlite3_exec: near "EXISTSusers": syntax error

answered Oct 17, 2012 at 8:59

CL.

182k18 gold badges241 silver badges282 bronze badges

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

Collectives™ on Stack Overflow

Create SQLite3 tables with C, but got an empty database file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related