2017-01-23 16:53 GMT+01:00 Clemens Ladisch <clem...@ladisch.de>: > Cecil Westerhof wrote: > >> UPDATE desktops > >> SET indexNo = indexNo + 1 > >> > >> But it does not, it gives: > >> Error: UNIQUE constraint failed: desktops.indexNo > > > > It is actually quite simple: > > PRAGMA ignore_check_constraints = ON > > A UNIQUE constraint is not a CHECK constraint. >
But it works. -- Cecil Westerhof _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
