Sorry about this, but this is a SQL question and not a SQLite specific question.
Is there a way to increment a value in a table in-situ. Without reading it, incrementing it, writing it? I need to insert an entry into a table, it has an id, all entries with id's >= the id need to be incremented to keep the id's unique ie 1 bob 2 joe 3 irene someone wants to insert 2 sarah, I need the table to look like this 1 bob 2 sarah 3 joe 4 irene Any help would be great. thanks ----------------------------------------------------------------- Gregor _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users