1) SELECT rowid,Id,Name FROM MyTable ORDER BY Name;
Rowid Id Name 4 4 aaa 3 3 bbb 2 2 xxx 1 1 zzz 2) "create table Temp as select Name from Mytable order by Name;" Rowid Id Name 1 4 aaa 2 3 bbb 3 2 xxx 4 1 zzz I wish to perform all operations in my code with sorted order of the Name field. So, to find the index of a name, which is in sorted order, I need the Rowid to be changed as shown in case 2 rather than in case 1. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
