On Tue, 2 Feb 2010 09:20:29 +0100, Carsten Peyk <c...@cpi.nu> wrote: >Hi, > > I have tried closing and opening the applications, > but the problem is still there. I have tried to > commit the changes for SQLLite Database Browser, > but SQLLite is responding with the message "No > active transactions". I'm sure that it is the same > database, because I rename it and tried starting > Spiceworks, whoch immediately created another .db > file besides the one I renamed. I think you're > right that is has something to do with transaction > isolation, but I don't know how to resolve it.
In some database browsers, you can edit cells in the data grid without updating the database at the same time. They usually have some "Update" button, which writes changed rows back. They may even ignore any changes when you close the application before clicking that button. Some database browsers might only be able to update the database from edits in the data grid when your table contains a primary key. I don't know how Spiceworks and SQLite Database Browser behave in that respect, but perhaps this help you analyse a bit further. >Carsten -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users