On 13 Oct 2017, at 3:32am, Fiona <cxfhn1...@gmail.com> wrote:
> delete/insert operations: > <http://sqlite.1065341.n5.nabble.com/file/t8403/delete.jpg> The two screenshots are useful. Your two commands do not have the same WHERE clause. I agree that it looks like they should have the same result, but obviously this is not working. Please take a backup copy of your database. Then, using the SQLite shell tool, starting with the same PRAMGA settings, I would like to see the results from these lines .mode quote PRAGMA count_changes; PRAGMA integrity_check; SELECT COUNT(*) FROM map WHERE tile_id='a37e1dba ….'; SELECT * FROM map WHERE zoom_level=18 AND tile_column=214233 AND tile_row=147702 AND tile_id='a37e1dba <whatever it is>'; DELETE FROM map WHERE zoom_level=18 AND tile_column=214233 AND tile_row=147702 AND tile_id='a37e1dba <whatever it is>'; SELECT * FROM map WHERE zoom_level=18 AND tile_column=214233 AND tile_row=147702; DELETE FROM map WHERE zoom_level=18 AND tile_column=214233 AND tile_row=147702; Use the full value for tile_id where indicated. I may also have made a mistake typing the other values above. Please check they match yours. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
