Hello Jay! Thank you very much for your help! Unluckily I can't get rowids on views. sqlite does not declare an error, when I select rowid, * on a view. - It just prints this column empty!
The problem is, that I have to sort first and then the numbering. So I can't use the table rowids of the base table. Please let me know, if there's any kind of workaround for this... best regards Hanno -- View this message in context: http://www.nabble.com/selecting-rows-of-the-view-via-its-position-tf1991602.html#a5469105 Sent from the SQLite forum at Nabble.com.
