[linux] Re: Last record in table

[Adam Goucher]

While I really have no expertise in the matter, you could look at soem
sort of locking strategy to lock the tbale you insterted into up nuntil
the select has taken place. Don't know how to do that, but...

-adam

On Fri, 28 Jan 2000, Pedro Fradique da Silva wrote:

> Hi all,
> After inserting a record I'm trying to retrieve the last record in a
> table(that would be the one I just inserted), so I can use one of its
> values in another insert.
> Is there a simple way to do it?
> How can I lock the database so that nothing is done between that first
> insert and the select?
> Thanks for any help,
> Pedro.
> 
> -- 
> Don't forget!  Abstracts are due January 25th 2000.  Act now and make your
> reservations for ODTUG 2000 -- the best conference of the new century!  See
> the website at http://www.odtug.com for full details.
> -- 
> Author: Pedro Fradique da Silva
>   INET: fradique na ipimar.pt
> 
> Fat City Network Services    -- (619) 538-5051  FAX: (619) 538-5051
> San Diego, California        -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru na fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-LINUX-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

-- 
Don't forget!  Abstracts are due January 25th 2000.  Act now and make your
reservations for ODTUG 2000 -- the best conference of the new century!  See
the website at http://www.odtug.com for full details.
-- 
Author: Adam Goucher
  INET: adam na ninjatactics.com

Fat City Network Services    -- (619) 538-5051  FAX: (619) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru na fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-LINUX-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).