Retrieving autoincrement field from SQLite using DBI



When you use DBI to add a new record to a SQLite table, for which the primary key column uses AUTOINCREMENT, is there a way to retrieve what was the ID value generated for the record you just added?
.



Relevant Pages

  • Re: Retrieving autoincrement field from SQLite using DBI
    ... Steve wrote: ... the primary key column uses AUTOINCREMENT, is there a way to retrieve what was the ID value generated for the record you just added? ...
    (comp.lang.perl.misc)
  • Re: pysqlite smart search
    ... I am trying to develop a tiny program using python to search inside sqlite ... database with file extension is .db in which the program will ask users to ... full key word in order to retrieve specific information. ...
    (comp.lang.python)
  • uniqueidentifier column
    ... I'm using a uniqueidentifier column as the "identity" primary key column for ... How can I retrieve the value of that column after an insert )? ... Fernando Chilvarguer ...
    (microsoft.public.sqlserver.programming)
  • uniqueidentifier column
    ... UniqueIdentifier. ... It must use newid() only. ... >How can I retrieve the value of that column after an ...
    (microsoft.public.sqlserver.programming)