> if I use the same sql statement will the > resultset be in the same order each time
Only if you use ORDER BY clause, and the set of columns in this clause have unique values for each row, and all these values don't change between query executions. Pavel On Wed, May 16, 2012 at 6:14 PM, Goatjugsoup <goatjugs...@hotmail.com> wrote: > > Well, a new thought just came to me, if I use the same sql statement will the > resultset be in the same order each time because if that is the case I > imagine I could use a for statement and an index to move through it the way > I want to with next inside of that as many times as it takes to get to where > I need. > -- > View this message in context: > http://old.nabble.com/How-do-you-access-a-specific-row-of-a-resultset--tp33856419p33861287.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
