Re: last insert
Posted in 2000
That will not work. For non-fragmented tables the ROWID is the physical address of the row on disk and is NOT sequential. For fragmented tables it IS similar to a SERIAL but cannot be depended on. Art S. Kagel "Josep M. Marti" wrote: > > You can use the rowid, is a internal number for every row in a table and you > can select max(rowid) and use this number for select the column. I think, the > rowid is like and internal "serial". > Bye, > > "Martin A. Marques" wrote: > > > is there a way to get the value of the last inserted element of a determined > > column of a table? > > > > Thanks!! > > > > -- > > "And I'm happy, because you make me feel good, about me." - Melvin Udall > > ----------------------------------------------------------------- > > Martín Marqués email: martin@math.unl.edu.ar > > Santa Fe - Argentina http://math.unl.edu.ar/~martin/ > > Administrador de sistemas en math.unl.edu.ar > > ----------------------------------------------------------------- > > -- > ------------------------------------------------------------------------ > > Gabinet Informàtic i Consultors > Departament de Programació > Josep M. Martí