SQLite3 open file problems

Question

I'm using GTK+ and SQLite as a front end for a small database program, and I cannot get SQLite to properly detect file type on open. Not matter what is opened, it returns SQLITE_OK.

I tried sqlite3_open and sqlite3_open_v2, the problem still persists. The output is always the same, regardless of what filetype is opened:

/home/shawn/Programming/languagedb/lang.db
0 6304656
good
/home/shawn/Programming/languagedb/Makefile
0 6304656
good

And here is the related code:

void OpenDialog()
{
    GtkWidget *WinOpen;

    WinOpen = gtk_file_chooser_dialog_new("Open Database",GTK_WINDOW(WinOpen),GTK_FILE_CHOOSER_ACTION_OPEN,GTK_STOCK_CANCEL,GTK_RESPONSE_CANCEL,GTK_STOCK_OPEN,GTK_RESPONSE_ACCEPT,NULL);

    if(GTK_RESPONSE_ACCEPT == gtk_dialog_run(GTK_DIALOG(WinOpen)))
    {
        char *filename;
        filename = gtk_file_chooser_get_filename(GTK_FILE_CHOOSER(WinOpen));
        printf("%s\n",filename);

        db = NULL;
        rc = sqlite3_open_v2(filename,&db,SQLITE_OPEN_READONLY,NULL);

        printf("%i %i\n",rc,&db);

        if(SQLITE_OK == rc && NULL != db)
        {
            printf("good\n");
        }

        sqlite3_close(db);
    }

    gtk_widget_destroy(WinOpen);
}

Community · Accepted Answer · 2017-05-23 12:26:46Z

1

As I also said in this answer you need to execute a non-pragma statement against the open database handle before SQLite tries to read, and then verify the file's contents.

edited May 23, 2017 at 12:26

CommunityBot

11 silver badge

answered Dec 12, 2009 at 21:04

Doug Currie

41.4k1 gold badge104 silver badges121 bronze badges

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

1 Comment

Shawn Buckley Over a year ago

Thanks. I wasn't sure what that meant, so I'll do some more research.

Collectives™ on Stack Overflow

SQLite3 open file problems

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related