On 25 Jul 2011, at 8:26am, Mattia wrote:
> I've tried doing transactions (committing and disposing them after each one)
> and yes, I've closed the database after doing my operations, with no luck at
> all.
You understand that you don't do this:
BEGIN TRANSACTION
insert 1
END TRANSACTION
BEGIN T
Hello, sorry for my late reply but I've been away the past week.
I've tried doing transactions (committing and disposing them after each one)
and yes, I've closed the database after doing my operations, with no luck at
all.
Mat.
2011/7/15 Simon Slavin
>
> On 15 Jul 2011, at 4:11pm, Jim Morris w
On 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 connection to new.db and ensure
> that the data is there.
>
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 connection to new.db and ensure
that the data is there.
Are you sure a commit is done before closing connectio
On 15 Jul 2011, at 9:26am, Mattia wrote:
> - checking the database with sqlite-administrator: same as before the
> execution. I controlled both data.db and new.db, just to be sure: no
> modification submitted.
>
>
> To create the databases and remove them I use the IO of the framework
> .Net. S
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/insertupdate (obtained from a string) to that ta
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/insertupdate (obtained from a string) to that table
> in the db-copy;
> - another select, with correct re
7 matches
Mail list logo
