Hello L> Lets assume that we have a very simple without any indexing or L>constraints. Now we have inserted some data to the table. When we do a L>simple "select" query, is it guranteed that the rows will be retrieved L>in the same order as they are inserted?
No. It may look like they are being selected in the order they were inserted. But there is no guarantee. So you should use an ORDER BY clause to get the order you want. Swithun. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users