On 14 Mar 2010, at 8:12pm, Max Vlasov wrote: > I'm not sure I understood you correctly, but the query > > INSERT INTO Books > (Author, Title) > VALUES > ((Select Max(rowid) FROM Authors), "test") > > just worked (tested it), sure you have to make id autoincrement to ensure > Max(rowid) is actually the last author
I can do it in the INSERT instruction, but I was hoping to make that value a default. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users