On Sat, Jul 13, 2013 at 1:53 PM, Keith Medcalf <kmedc...@dessus.com> wrote:
> > I don't know. It works entirely as expected. If I move a row (via > update) that I have already visited into a position where it is "yet to be > visited", then I will visit it twice -- both times exactly when and where > expected. > Please try again after adding "ORDER BY +rowid" to the query. The "+" before "rowid" is important in the previous. If you already have an ORDER BY clause on your query, simply add a "+" sign to the first term. Let me know if the row still gets visited twice. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users