Hello L> Thanks Swithun. I dont have any supportive column in table to issue L> "order by". Can it be achieved by issuing an "ordr by" query on L> "row_id" (used by sqlite internaly)?
You could, I think. But it might be better style to create an INTEGER PRIMARY KEY AUTOINCREMENT column to do this explicitly. One advantage of this is that if your table gets so large that all the 64 bit integers have been used up, then you won't be able to insert any more rows. Without the AUTOINCREMENT, the database will start to reuse numbers from rows that got deleted. That at least, is what I understand from reading http://www.sqlite.org/autoinc.html and http://www.sqlite.org/lang_createtable.html Swithun. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users