On Fri, Sep 6, 2013 at 5:41 PM, ibrahim <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
