Re: last insert

After you insert the new row you can get the number using: let numserial = sqlca.sqlerrd[2] and put this number in the referenced table. Bye, "Martin A. Marques" wrote: > On Wed, 28 Jun 2000, Obnoxio The Clown wrote: > > From: "Martin A. Marques" <martin@math.unl.edu.ar> > > > > > >is there a way to get the value of the last inserted element of a > > >determined > > >column of a table? > > > > Depends on many things, but probably not. > > OK! Lets say I inserted a row, which has a SERIAL data column (and some other > columns), which is autoincremental, and I insert a 0! How do I get the number > that Informix put in that column to reference that row on another table? > > -- > "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í