On 1 Nov 2016, at 6:56am, GB <gbi...@web.de> wrote: > And that is why several SQL Engines prevent AUTOINCREMENT columns from being > UPDATEd.
I think that would be a good fix in SQLite's case. If you're relying on SQLite to generate these unique numbers for you then you shouldn't then change your mind and try to correct one of its attempts. Unfortunately the response is going to be along the lines of "We can't do this for compatibility reasons because there might be a program out there that does it.". Roll on SQLite 4 in which this argument cannot apply. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users