In my wxPython-app a part of it gathers data, when a button is pressed, and stores it into a db.
The GUI part should display the stuff being stored in the db. When both parts work on the same connection, I get "SQL statements in progress errors". Seems ok to me, you can't do that. So, next step: Both parts get a separate connection. Now I get "Database locked" errors. Hmm, yes, it's GUI stuff after all, being all in the same thread. So, next step: I put the data gathering part into a real thread, that's started, wehn the "Scan" button is pressed. This way the "Database locked"- errors should got away. But now I get "SQLite objects created in a thread can only be used in that same thread.The object was created in thread id 3576 and this is thread id 1040". Hmm, true, I want to display db content, that was stored by an other thread. But that's what multi-threading capabilities are for! I must be missing something here. Anyway, I'm a bit lost now, really. So, how are you doing such stuff with pysqlite? Kind regards Franz GEIGER -- http://mail.python.org/mailman/listinfo/python-list
