On Fri, Sep 6, 2013 at 5:41 PM, ibrahim <ibrahim.a...@googlemail.com> wrote:
> You can let sqlite handle the creation of a temporary table by : > > update t1 set seq=seq+1 where pk in (select pk from t1 where seq >= 3 > order by seq desc) ; > > afterwards you can insert. Unless I'm misunderstanding you, I already tried that in an earlier post of this thread, and that didn't work. Give it a try. --DD _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users