> The insert statement is a “insert or replace into…” so I don’t have to
> deal with insertion errors. However, I expected the rowid to not change
> when the row has not changed.
The OR REPLACE clause just deletes any old row.
If you want to update the old row, use UPDATE. (And there's no good way
to do this with a single SQL statement.)
sqlite-users mailing list