I never said that it has something to do with transaction isolation - if you have no transactions active then there's nothing to isolate. Again: if after restart of applications they still see their own changes and don't see other's changes then you definitely working with different databases. BTW, the best way to check what is actually in the database and what is made up by applications in some way is to look into the database with command line utility which is downloadable from SQLite's site.
Pavel On Tue, Feb 2, 2010 at 3:20 AM, 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. > > Carsten > > > -----Oprindelig meddelelse----- > Fra: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] > På vegne af Pavel Ivanov > Sendt: 1. februar 2010 19:01 > Til: General Discussion of SQLite Database > Emne: Re: [sqlite] Update/Delete problem > > Are you sure that Spiceworks or SQLLite Database Browser commit your > changes? What happens if you close those applications and restart it - > will they see their own changes? If they will and they still won't see > other application's changes then you can be sure that you're looking > at different databases. > > Pavel > > On Mon, Feb 1, 2010 at 12:34 PM, Carsten Peyk <c...@cpi.nu> wrote: >> Hi, >> >> I'm completely new to SQLLite, and I'm very sorry if I ask a trivial >> question. >> >> I'm using Spiceworks which again uses SQLLite as backend database. I've made >> some updates and deletions to the records using the freeware SQLLite >> Database Browser application. If I the open Spiceworks application the >> changes are not reflected. Furthermore changes made in the Spiceworks >> application are not reflected when opening the database in SQLLite Database >> Browser application. I'm sure that it is the same database that I'm looking >> at. I can open the database in either of the two applications, and they show >> different results. Somehow it seems that the changes I made are still >> pending - uncommitted. Is this possible, and what can I do to "reset" any >> changes I've made. >> >> Thanks. >> >> Kind regards >> Carsten >> Before printing, think about the environment >> >> >> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
