Hello, I try to update a row of a Sqlite3 Database with the c++ api using the following lines of code:
char dbquery[1024]; int rc; sprintf(dbquery, "update zeit_tabelle set zeit = %d where username like '%s';", 12345, test); rc = sqlite3_exec(db, dbquery, 0, 0, 0); The returned rc is 14, that means SQLITE_CANTOPEN according to the documentation. Reading the database with "select" querys works perfectly though. The permissions for the database file itsself are set to 777 in unix, so everyone is allowed to do anything to it. The update statement also works using the command line tools, so it should be correct. Is there any lock I need to aquire to be able to change the database? In the documentation, it seems as if it would be done automatically... or is there anything else I am missing? Any help would be greatly appreciated. Thanks a lot in advance, regards, Christiane
