Hello Everyone:
I am trying to delete a SQLite database(file) through C++, which is created using php file. I am getting the SQLITE_BUSY error and was not able to solve it.
Creating the database in PHP:
$dir = 'sqlite:C:/Program Files/x/'.$DataBaseName.'.sqlite';
$database = new PDO($dir) or die("cannot open the database");
Accessing and Deleting the database in C++:
function1()
{
bool delete = false;
delete = HandleDataBase(name);
if(delete)
remove(filename);}
HandleDataBase(name)
{
sqlite3 *database;
if(sqlite3_open(name, &database) == SQLITE_OK) {
const char *pSQL[6];
pSQL[0] = "select * from Table1";
sqlite3_stmt *statement1;
if ( sqlite3_prepare(database, pSQL[0], -1, &statement1, 0 ) == SQLITE_OK ) {
}
int rc = sqlite3_close(database); if ( rc == SQLITE_BUSY)
{
bool busy = true; }
return true; }
return false;
}
How do i solve my issue, how should i close the database after reading and updating information(using sqlite3_prepare) so that i can delete it?