On 7 Jan 2010, at 1:15pm, Jay A. Kreibich wrote: > There isn't a correct way of doing this. You need to manually loop > over the SELECT, do the INSERT, and call sqlite3_last_insert_rowid() > (or the SQL function last_insert_rowid()) after each INSERT to build > up a collection of ROWIDs.
One other aspect is this: you are taking what should be an internal function of SQLite and using it for your own purposes. This is sometimes a bad idea. If you want to have a column with particular values in which you use for your own purposes, make your own column and put whatever values into it you want. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
