SQLITE: database is locked error (error - 5) when used update query

Question

int nRet = sqlite3_open(szFile, &mpDB);

if (nRet != SQLITE_OK)
{

}

setBusyTimeout(mnBusyTimeoutMs);

   sqlite3_exec(mpDB, "Begin Transaction;", 0, 0, &szError);
  sqlite3_exec(mpDB, "UPDATE query", 0, 0, &szError);//some update table query
sqlite3_exec(mpDB, "Commit Transaction;", 0, 0, &szError);///Here it gives error database is locked

Above code works fine for insert command instead of update command.

Answer 1

Do you have that file opened in some sql editor, in the same time? I've recently used program called "SQLite database browser" and it locked my whole sqlite database, it took me some time to find out what the hell is going on.