title: sqlite3:Unable to close due to unfinalised statements
body: <p>I have two sqlite connections and execute like below(CMyDatabase is a derived class of sqlite3):</p>
  
  <pre><code>CMyDatabase* dbConnection1 = new CMyDatabase;
  dbConnection1-&gt;OpenDataBase(CQCommon::GetModulePath() + L"test.db");
  
  CMyDatabase* dbConnection2 = new CMyDatabase;
  dbConnection2-&gt;OpenDataBase(CQCommon::GetModulePath() + L"test.db");
  
  dbConnection2-&gt;BeginTrans();
  CString updateStr("update ImageAlbumEntry set ImageID = 2 where ID = 1;");
  dbConnection2-&gt;ExecNoQuery(updateStr);
  CString queryStr("select ImageID from ImageAlbumEntry where ID = 1;");
  CppSQLite3Query queryResult;
  dbConnection2-&gt;ExecQuery(queryStr, queryResult);
  cout&lt;&lt;queryResult.getIntField(0)&lt;&lt;endl;
  dbConnection2-&gt;EndTrans(TRUE);
  
  dbConnection2-&gt;CloseDataBase();
  dbConnection1-&gt;CloseDataBase();
  </code></pre>
  
  <p>Now when I invoke dbConnection1->CloseDataBase(). I met with the error stated as 'Unable to close due to unfinalised statements'. Can anyone explain the reason and resolve method of the problem? Thank you!</p>