xskater11x wrote:I know for a fact it is hanging on the query itself, but I have no clue why it is doing so.
I guess it has something to do how you use SQLite in your application. Since I know only the small bit of code you posted here, it's hard to tell what's going wrong.
Maybe your application tries to access the database from different threads. You definitely can't use the same instance of wxSQLite3Database from more than one thread. Please read http://www.sqlite.org/faq.html#q8
for further details of SQLite's threadsafety.
xskater11x wrote:I also cannot run in debug mode due to Python embedding, python24 does not come with a debug library, rendering debug compilation impossible without removal of the python scripting.
In that case the only way to debug the application will be adding the output of messages to a file for example at various points in the application.
xskater11x wrote:So I have been going off the little amount of debug information release build gives out. Stepping through via comments showed me the query is not properly working though. The same query executed via the sqlite3 console application returned the correct value though.
What do you mean with "not properly working"? In your first posting you told that you get an unhandled exception. After adding exception handling code you told your program "hangs". This is weird. I would have expected you would actually "see" the exception message.
If your application really hangs then my guess is you have a concurrency problem.