On 1 Nov 2013, at 4:59am, Igor Korot <ikoro...@gmail.com> wrote: > I'm not sure I understand. > Are you saying that I don't have to populate the rank in the table on > insertion?
Yes. >> Given your description above, why try to get all the ranks right every time >> you do an INSERT ? > > Because right after insert I am displaying those records and the rank > field is the second field in the sorting algorithm. > So, on creating the league I do an insert and then do a sorting and > display all those records. Do your insert, making sure you put the player's value into a playersValue column. Then SELECT * FROM myTable ORDER BY playersValue DESC Then number the rows in the order they're retrieved. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
