2017-01-23 16:53 GMT+01:00 Clemens Ladisch <[email protected]>: > 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
