I have an application I'm using sqlite3 as the database for. The program is designed to view and add/edit information. The viewing part is set up and working nicely using pysqlite and wxpython.
What the problem is is from viewing trying to add data. I get a database is locked error. I think my problem is I've opened the database in different modules for different views of the data (there are six tables, one of which relates to two/three others, another which relates to one other) and therefore the database is locked for anything like adding data. I've looked for ways to mitigate this behavior, globalizing the database access perhaps, or simply making the add functions a totally separate program (which would be, I think, a poor way to do this). It might help if there were wsome way to determine the database status in some way which could tell me what state it's in (open for viewing, locked, unlocked, etc). Can anyone help with some clues for me? Thanks, Mark _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
