Hi all,

I've got some relatively simple code that does a query and then
does the following:

    const char *stmt = "DELETE FROM connect WHERE machine = 'xxx';" ;

    printf ("Before : %s\n", sqlite3_errmsg (pdb)) ;
    sqlite3_exec (pdb, stmt, NULL, NULL, NULL) ;
    printf ("After : %s\n", sqlite3_errmsg (pdb)) ;

The query that happens before this works as expected and then the
above results in:

    Before : not an error
    After : unable to open database file

Obviously, at the 'Before', the database was open and valid so I 
don't understand why it returns a database not open error after the
sqlite_exec() statement.

I'm using the default sqlite libs on Ubuntu Hardy:

    ii  libsqlite3-0      3.4.2-2      SQLite 3 shared library
    ii  libsqlite3-dev    3.4.2-2      SQLite 3 development files

Anyone have any clues as to what could be going on here?

Cheers,
Erik
-- 
----------------------------------------------------------------------
Erik de Castro Lopo
http://www.mega-nerd.com/
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to