[sqlite] How to circumvent UNIQUE constraint

[Cecil Westerhof]

I have the following (work in progress) table:
CREATE  TABLE desktops(
    name        TEXT    NOT NULL PRIMARY KEY,
    indexNo     INTEGER NOT NULL UNIQUE,
    value       TEXT    NOT NULL UNIQUE,
    waitSeconds INTEGER NOT NULL
);

​I want to insert a record in front of​ the others, so indexNo has to be
increased with one for all records. I would think that this would work:
UPDATE desktops
SET indexNo = indexNo  + 1

But it does not, it gives:
Error: UNIQUE constraint failed: desktops.indexNo

​How can I make this work?

-- 
Cecil Westerhof
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users