Dave Nation wrote: > Hi, > > I'm running Dabo (0.9a rev:3308) on Win-XP with Python 25 wxPython > 2.8.1.1 with a SQLite database. > > I am getting problems when the bizobj requeries the database. I have > simplified the query down to a single table and get the problem with > some filter combinations but not others. I suspect the problem may be > data related and/or down in the framework. Looking at the table with > TkSQLite I cannot see any differences that might account for the problem. > > When a filter combination fails, it fails every time, and a combination > that works will always work. > > I show below a working query and a failing one, run on the same database > with same program. > > After getting the error message, if I try to do other working queries, I > get a message 'sqlite3.OperationError: database is locked'. > > Hope you can help.
I see your resulting SQL but I'd also like to see your code. Also, please turn on database activity logging and post that. Turn on db activity logging by doing something like: app.DatabaseActivityLog = r"c:\temp\dabo_db_log.txt" Thanks! -- pkm ~ http://paulmcnett.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
