On 29 Jun 2012, at 12:47pm, Dennis Volodomanov <i...@psunrise.com> wrote:
> Ok, tried using the shell and the result is the same as using my app.
>
> What I did is:
>
> 1) delete the database file ("mydbname.ext") from the DOS prompt, make sure
> the file is not there
> 2) run "sqlite3 .\mydbname.ext" from within that same folder, same DOS prompt
> 3) type .dump
> 4) see entries in this DB, which should be impossible, since the file wasn't
> there and I've issued no commands using the shell tool
When you're deleting the database file, look for any other files in the same
folder with names that start with "mydbname" and anything after that, including
any extension. (Marcus's theory) Tell us what they're called.
Make sure you're quitting the shell tool with '.quit', not just CTRL-C ing out
of it.
First try the above two. If they don't explain what's wrong,
Using the shell tool, delete one of the rows which has magically appeared. Or
even the whole table. Make another row or table with different data in. Then
repeat the quit & delete procedure.
When you go back into the shell tool, do you get the same old bad data or the
new bad data ?
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
