On 8 Feb 2019, at 1:49pm, Ludovic Gasc Lemaire <gml...@gmail.com> wrote:

> Thanks for your tip, this command has found problems, see below.
> It should explain this strange behavior with DELETE ?

Yes.  The corruption you have found in your database can explain lots of weird 
and non-standard behaviour.  In fact, even if you can get commands to work now, 
you may lose data later.  Do not proceed with this database.

You may be able to rescue some or all of the data from this database.  To do 
this use the SQLite CLI tool to dump the database as SQL commands, then create 
a new database file by executing those commands.  If you're not familiar with 
'.dump' and '.read', you can find more details here:

<https://sqlite.org/cli.html#converting_an_entire_database_to_an_ascii_text_file>



Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to