2017-01-21 21:44 GMT+01:00 James K. Lowden <[email protected]>:
> On Sat, 21 Jan 2017 19:33:06 +0200 > R Smith <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
