"Pramoda M. A" <pramod...@kpitcummins.com> wrote in message news:f7846b8f3c78c049b6a1dff861f6c16f03e94...@kcinblrexb01.kpit.com > But how to get the rows in the same order of insertion? > Say, I will insert 2 3 4 and it will store in 2 4 3. But I need in > the order 2 3 4. Is it possible?
You would need a column to store some kind of ordinal or timestamp, set to increasing values when inserting, so you can order on it when selecting. See http://sqlite.org/autoinc.html - you can get SQLite to maintain just such a column for you automatically. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
