On 11 Sep 2016, at 10:53pm, mikeegg1 <mikee...@mac.com> wrote: > Thanks. I thought not. I’m doing this from PERL on a Mac and don’t know if I > can fully access last_row_id().
It's not a C function, it's a function you can use inside SQL commands. There shouldn't be a problem with it. INSERT INTO myTable VALUES ('Hastings',17); UPDATE anotherTable SET theRowId = last_row_id() WHERE placeName = 'Hastings'; Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users