>> In the next query, dump any rows where (title = >> last_seen_title) and (rowid != last_seen_rowid). > > Up until you hit the last seen rowid, yes. That was my first idea as > well.
Right. Tried it in a quick prototype and it seemed to worked okay. > The big thing to remember is that the rowids aren't going to be > ordered in any way. Their main useful property, in this context, is I was actually trying to think if there was a way to do that. Have a column of a view that was just an incrementing sequence. Then its a simple matter of using this virtual index to search for the next on-screen window. Really have to take some time to learn about these custom functions. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users