On Mon, 16 Jun 2008 10:36:18 -0600, you wrote: >Hi, thanks this is great. Of course I forgot to mention that the id >is a primary key, so I get an error about duplicate primary keys. > >I tried this: > >update binary_report_fmt set column_id = column_id + 1 where column_id >= (select column_id from binary_report_fmt where column_id >= 3 order >by column_id desc); > >but it only updates the last item. I guess I can make it a non- >primary key..then it works perfectly. > >Gregor
Add a large value to all column_id that have to be changed, then subtract that same value minus 1. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users