Re: last insert
This will not work on SE if rows are deleted from the table. The rowid represents the physical position in the table. If a row is deleted, a newly inserted row might go into the empty slot and inherit that rowid - and will therefore not be the max rowid on the table. "Josep M. Marti" <soft@gic.es> wrote in message news:3959FD19.6BA2E882@gic.es... > 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' > >
Also, I had heard that ROWIDs were going away and wouldn't be supported anymore. I don't know if this is actually true, but... In article <Dgo65.201$d3.190@news1.iquest.net>, "Ed Brown" <ebrown@computer-systems.com> wrote: > This will not work on SE if rows are deleted from the table. The rowid > represents the physical position in the table. If a row is deleted, a newly > inserted row might go into the empty slot and inherit that rowid - and will > therefore not be the max rowid on the table. > > "Josep M. Marti" <soft@gic.es> wrote in message > news:3959FD19.6BA2E882@gic.es... > > 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' > > > > > > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.