"Pramoda M. A" <[email protected]> wrote in message news:[email protected] > 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
