Re: Retrieving Serial Value

You can get this info using the "dbinfo" SQL statement. You don't need to lock the table. The "dbinfo" statement is in the SQL guide. Hope this helps. Brice anil kuttappan wrote: > Hi , > > I would like somebody to help me out with this. > > I have a table with serial column. > In a multiuser environment suppose user A inserts > a row inthe table and wants to retrieve the serial > value for the row he just inserted, how do i get it. > considering the fact that user B might have also > inserted a row while user A did a select to find its > value. > > So the question is how to retrieve the serial value > for the row which User A inserted. > > I know locking the concerned table and doing a select > to get the last value followed by an insert of a new > row and a commit is one alternative, > but i would like to know if there is any other way > out. > > Thanks > > Anil K > > ===== > Anil Kuttappan Mailto: anil_kuttapan@yahoo.com > > __________________________________________________ > Do You Yahoo!? > Talk to your friends online with Yahoo! Messenger. > http://im.yahoo.com