>> 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

Reply via email to