"Ian Walters" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > What I'm trying to do is create an ordered table in SQLite that I can > then look up by row number. If performance isn't considered this is > actually quite easy. For example > > CREATE TEMPORARY TABLE mytable AS ... complex select statement ordered > by label, recordId ....; > CREATE INDEX ON mytable (label, recordId); > > SELECT recordId, label FROM mytable ORDER BY label, recordId LIMIT 1 > OFFSET row;
See if this helps: http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
