2009/8/21 John Loveys <john.lov...@nautel.com>: > Hi All > I am hoping the rowid is sequential. Then I can simply get the biggest > rowid (using sqlite3_last_insert_rowid), subtract N from it and delete rows > where rowid < last_rowid - N. Can anyone confirm the rowid is guaranteed > sequential in my scenario? Are the any gotchas I should know about? > Thanks, > John
http://www.sqlite.org/autoinc.html cite/ If a table contains a column of type INTEGER PRIMARY KEY, then that column becomes an alias for the ROWID. /cite Yes -- Kit _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users