Hi All, I searched trough many messages and docs but did not find a solution to this trivial looking problem. It would be really nice if someone could point me into the right direction. my ToDo: I have to use a virtual listview for a database with some medium and large tables. I would give the user the opportunity to select the active displayed sorting order with a click on the corresponding listview header. To get the necessary number of records for the table with high performance, even for large files, this can be done with a trigger that updates a record elsewhere with every delete or insert operation.
My Problem: how to get the relative position for the selected row depending on the selected “order by” clause as fast as possible? An estimate should be enough to position the scrollbar. Thanks for any hints. George _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
