Hi, I'm trying to solve this problem: I've got the following table, made up of two fields:
ID INTEGER, Name TEXT So, for instance, I can have: 1 Julia 2 Eric 3 Kevin 4 Sarah 5 John Now I wanna move Eric from 2 to 4 in order to yield (by performing a series of UPDATE of ID field): 1 Julia 2 Kevin 3 Sarah 4 Eric 5 John What's the correct sequence of SQL statements to accomplish a such kind of task? Obviously I could also want to move the records in the opposite order (3 to 1) Cheers _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
