ststeiger / managed-sqlite Goto Github PK

What steps will reproduce the problem?
1. Open database
2. Use TableExists() method
3. Close database - an Exception is thrown

What is the expected output? What do you see instead?
TableExists() should finalize the query it internally uses

What version of the product are you using? On what operating system?


Please provide any additional information below.

And here is the url:
web page: http://sqlite.phxsoftware.com/
project on sf.net: http://sourceforge.net/projects/sqlite-dotnet2

What steps will reproduce the problem?
1. Create a VS2005 project with some code that works with ManagedSqlite
2. Run the compiled exe on a 64 bit version of windows 2003

The program does not run, instead it says: Could not load file or assembly
'ManagedSQLite,...

What steps will reproduce the problem?
1. Call BeginTransaction
2. Execute Query(s)
3. Call CommitTransaction
4. Close Database

What is the expected output? What do you see instead?
Expected: The Database is closed. Actual: "Unable to close due to 
unfinalized statements"

What version of the product are you using? On what operating system?
1.0.0.01340 (SQLite 3.4.0 with FTS1 and FTS2)

OS: Windows XP Pro

Please provide any additional information below.

The methods should be something similar to:

void Database::BeginTransaction()
{
    Query ^q = ExecuteQuery(_T("BEGIN TRANSACTION;"));
    q->FinalizeQuery();
}
void Database::CommitTransaction()
{
    Query ^q = ExecuteQuery(_T("COMMIT TRANSACTION;"));
    q->FinalizeQuery();
}
/* I Added this. */
void Database::RollbackTransaction()
{
    Query ^q = ExecuteQuery(_T("ROLLBACK TRANSACTION;"));
    q->FinalizeQuery();
}
void Database::EndTransaction()
{
    Query ^q = ExecuteQuery(_T("END TRANSACTION;"));
    q->FinalizeQuery();
}