Hi, I'm using sqlite 2.8.12 and have a problem in deleting rows from a database. The sql statement which don't work in my C++ code was: C++ Code Segment: sql = "DELETE FROM table_1 WHERE path='/daten2/documents/my_file.txt';"; if(SQLITE_OK != sqlite_compile(db, sql, &sqltail, &dbcursor, &dberr)) { cout << "Error:" << dberr << endl; free (dberr); } else { cout << "Success:" << endl; sqlite_finalize(dbcursor, NULL); }
The code segment returns a Success, but the matching file won't be deleted from the database. Other sql statements are working verry well. When I try to use the sqlite program instead of invoking the command via the C interface and enters the command per command line it was removed out of the database: sqlite> DELETE FROM table_1 WHERE path='/daten2/documents/my_file.txt'; Know the file was removed out of the database. Any hints are welcome. Kind Regards Holger