I forgot I could use it inside the shell. Thanks.
Mike
> On Sep 11, 2016, at 16:58, Simon Slavin <slav...@bigfraud.org> wrote:
>
>
> 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
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
