Dewey Gaedcke wrote: > > For example, if my query returns 80 rows, I'd like an extra column holding > sequential values 1 to 80 to help with paging >
Check out this information page http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor It explains how to do paging efficiently in SQLite. HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
