2017-01-21 21:44 GMT+01:00 James K. Lowden <jklow...@schemamania.org>:
> On Sat, 21 Jan 2017 19:33:06 +0200 > R Smith <rsm...@rsweb.co.za> wrote: > > > UPDATE desktops SET indexNo = -indexNo - 1 WHERE indexNo >= X; > > INSERT INTO desktops ... new row for indexNo X ... ; > > UPDATE desktops SET indexNo = -indexNo WHERE indexNo < 0; > > unless > > FOREIGN KEY indexNo references foo(bar) > or > FOREIGN KEY bar references desktops(indexNo) > In this case it is only used to determine the order of the records. -- Cecil Westerhof _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
