"Wenton Thomas" <thomas.wen...@yahoo.com> wrote in message news:790786.83985...@web111003.mail.gq1.yahoo.com > If "order by" isn't used in a select statment, does the result > records ordered in rowid?
Generally, no. It could accidentally happen this way, but there's no guarantee. If you want a particular order (by rowid or otherwise), request it with ORDER BY clause. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users