last insert

Posted in 2000

Martin A. Marques — Wed, 28 Jun 2000 08:29:31 -0300 — source: Informix-list mailing list archive (1991-1998)

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 -----------------------------------------------------------------

↪ replying to Martin A. Marques

Josep M. Marti — Wed, 28 Jun 2000 15:26:51 +0200 — source: Informix-list mailing list archive (1991-1998)

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í