Re: Retrieving autoincrement field from SQLite using DBI



Steve wrote:
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?

last_insert_id() didn't work?
.



Relevant Pages

  • 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? ...
    (comp.lang.perl.misc)
  • Re: shadow copy in server
    ... Give it a try Steve. ... retrieve back, i will have to use the properties on the folder(parent ... recover deleted files since the original is no longer there ... The 'storage area' is also in d: ...
    (microsoft.public.windows.server.active_directory)
  • Re: Err object spontaneously resetting
    ... Steve wrote: ... >>So something happens to cause an error (in this case the DLL tries to ... >>handle this, but the act of trying to retrieve the item causes the error), ...
    (microsoft.public.vb.bugs)
  • Re: What is retrieved by using User.Identity.Name?
    ... Steve C. ... Kai wrote: ... but I don't want to retrieve anything from the Active Directory. ... One user logs in with DOM\UserA but it returns DOM\userA. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Retrieving data from a password protected site
    ... I am trying to retrieve a page from a site that is password protected ... Is this the most elegant way to achieve the goal ... Steve ... Prev by Date: ...
    (microsoft.public.excel.programming)