Max Vlasov wrote: > I have a query "INSERT ... SELECT" and after it performed it I have to to > store range of rowids (autoincrement) of the inserted rows. While max(rowid) > for right bound seems ok, assuming max(rowid)+1 for the left bound (before > the query) depends on the fact whether there were deletes from the table > before. If there were deletes, my estimation will differ from the actual > value. So is there a correct way to know the range of rowids in this case or > just to know for sure "expected" rowid in similar cases?
If by autoincrement you mean a column actually declared with the AUTOINCREMENT keyword, then the next ID is stored in SQLITE_SEQUENCE table. For details, see http://www.sqlite.org/autoinc.html Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
