Re: [sqlite] System.Data.SQLite: commands not persisting on db.

2011-07-25 Thread Mattia
15 Jul 2011, at 4:11pm, Jim Morris wrote: > > > On 7/15/2011 1:26 AM, Mattia wrote: > >> - deleting the old database (data.db) and renaming new.db with the > >> correct name (new.db becomes data.db). > > After this step, as a test, reopen the conn

Re: [sqlite] System.Data.SQLite: commands not persisting on db.

2011-07-15 Thread Mattia
Simon Slavin > Thu, 14 Jul 2011 09:24:35 -0700 > On 14 Jul 2011, at 5:13pm, Mattia wrote: > > So actually what I do is: > > - run the application; > > - make a copy of the database; > > - select to see what lies inside a table; > > - an insert/delete/

[sqlite] System.Data.SQLite: commands not persisting on db.

2011-07-14 Thread Mattia
Hello everyone. I'm a bit embarassed with a problem I am facing, while using System.Data.SQLite to send commands to my database. The sad thing is that if I query the database before and after (with a simple select statement) the block of commands I obtain the expected results, but when I open the