Igor Korot wrote: > what I'm looking for is a way to populate the current_rank and > original_rank in the leagueplayers table. They should come up as > auto-incremented values.
Autoincrementing works only for INTEGER PRIMARY KEY columns. > Is there a way to do that or I will have to change the query to do a > transactional routine? You could create a temporary table with such a column. Doing this in your code might be simpler. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
