Shawn Wilsher <[EMAIL PROTECTED]> wrote: > I was wondering if we could set the value that an AUTOINCREMENT starts > at for temporary tables. Right now we are looking at having to manage > it ourselves, but if we could use sqlite to handle it, as long as it > starts at the right value, that would be ideal.
http://sqlite.org/autoinc.html Read about SQLITE_SEQUENCE table. Simply update the starting count there before inserting any rows. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users