Re: How to select the last item's ID

From: Amin Emami <Amin_Emami_at_yahoo.com>
Date: Tue, 4 Sep 2001 20:10:45 +0430
Message-ID: <9n2sj5$506a8$1@ID-101160.news.dfncis.de>

David,

sequence_name.currval --> current value sequence_name.nextval --> next value
thanks,
Amin Emami
http://www.aminemami.f2s.com

"David Lee" <pritino2020_at_yahoo.com.tw> wrote in message news:9n2jpk$2lbf0$1_at_news.shem.etwebs.com...
> I am really sorry about this, but is it possible for you to show me an
> example? Thanks!
>
> "Davide Bianchi" <davidebianchi_at_davidebianchi.net> ¼¶¼g©ó¶l¥ó
> news:9n2jo1$4scm0$1_at_ID-18487.news.dfncis.de...
> > "David Lee" <pritino2020_at_yahoo.com.tw> wrote in message
> > news:9n2i6h$2n5t1$1_at_news.shem.etwebs.com...
> > > After I inserted a row of data, how do I retrieve the
> > > auto-increment ID of this row ?
> >
> > If you are using a SEQUENCE, you just ask for the
> > NEXT value of the sequence and then use that as ID for
> > your table (so, there is no automatic insertion).
> > Otherwise, you can use a Stored Procedure that insert
> > the data and return the generated ID.
> >
> > Davide
> >
> >
> >
>
>
Received on Tue Sep 04 2001 - 10:40:45 CDT