On 10/12/17, Fiona <cxfhn1...@gmail.com> wrote:
> As you can see, insert works, and I can also delete/update this last
> inserted record. It seems some pages of my db file is locked or something.

Before running your query, enter ".mode quote".  Then show us what the
output of this query is:

SELECT typeof(tile_id), tile_id FROM map WHERE zoom_level=18 AND
tile_column=214233 AND tile_row=147702;

D. Richard Hipp
sqlite-users mailing list

Reply via email to