Hi. maybe it is bug sqlite I'm not sure exactly. and decided to CREATE
POST.
for unknown reasons sqlite3_close() == SQLITE_BUSY, sqlite blocked data base
file. I find on the forum next code:
void CSQLiteDB::Close()
{
if(m_db)
{
sqlite3 *db = m_db;
m_db = NULL;
int rc = sqlite3_close(db);
while( rc == SQLITE_BUSY)
{
// set rc to something that will exit the while loop
rc = SQLITE_OK;
sqlite3_stmt * stmt = sqlite3_next_stmt(db, NULL);
if(stmt != NULL)
{
rc = sqlite3_finalize(stmt);
if(rc == SQLITE_OK)
{
rc = sqlite3_close(db);
}
}
}
}
}
But after delete old data base i can`t create new! ExecSQL() - not create
table. help me in this question.
Thanks for help.
--
View this message in context:
http://old.nabble.com/sqlite3_close%28%29-blocked-data-base-file-tp33292831p33292831.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
