Let's say I've just added a record to a table where one of the columns is designated an integer primary key, and I have sqlite autoincrement that column for me with each insert. Now I need to add some records to other tables linked to the first record. So I want to use the first record's PK value as the foreign key for all these other records. How can I get the first record's PK? I'm a newbie, so I can think of all sorts of ways that seem awkward to me, but I assume there's a simple, built-in method. I just can't find it. Thanks.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
