On 13 Jul 2010, at 6:53am, Lloyd wrote: > I dont have any supportive column in table to issue "order > by". Can it be achieved by issuing an "ordr by" query on "row_id" (used by > sqlite internaly)?
No consistently. Because unless you're using a rowid column you declared yourself, even the values in the rowid column can change. Either declare your own rowid column (you can add a new column to a TABLE after it was originally declared), or declare a column even better suited to ordering your rows. Simon. PS: New text /below/ text you're quoting, please. English is read from top to bottom. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users