SQLce Select query problem

Question

Wrote a Truck show Contest voting app, financial etc using sqlite. decided to write backup app for show day using ce 3.5. Created db moved to data directory, created tables configured dgridviews all is well. Entered some test data started management studio 08 ran select query against table and got null returns. Started app from vs studio and found that test data is gone. Re entered data ran query in MS data gone again.

If I use VS Studio can start and enter data, close app restart and data is still there, seems only when using outside tool on select query data deletes.

I don't know CE that well but this cannot be right.

select * from votes = delete * from votes??????????????

Answer 1

You're probably overwriting the database during your build.

Answer 2

See http://erikej.blogspot.com/2010/05/faq-why-does-my-changes-not-get-saved.html