Hi guys, Is it possible to get key number from the index? For example let's consider Figure 4: An Index On The Fruit Column from here https://www.sqlite.org/queryplanner.html
index_rownum, fruit, rowid 1 Apple 2 2 Grape 5 3 Lemon 18 4 Orange 1 5 Orange 23 ... Is it possible to add rownum column and store it in the index? And get it in the query? Here is my task. I show DataGrid to a user and he/she can click a column header to change the sorting. And I want to preserve selected record (user's cursor) when sorting changes. I query visible data only (pagination). I can remember rowid of selected record before sorting. But how can I find which range of records to query so that selected record would be in this range? Thanks, Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users