Re: geting the last record's field value

Posted in 2000

Obnoxio The Clown — Mon, 17 Apr 2000 18:29:16 BST — source: Informix-list mailing list archive (1991-1998)

From: cornelhughes@netscape.net > >I am trying to get the last serial value in order to insert another >record which would have as its value the prior records cust_id field >(which is a serial field type) value + 1. Does anyone know of a way to >do this? > >I have tried using select dbinfo('sqlca.sqlerrd1') from systables where >tabid = 122 but I keep on getting 0. Sure you're not doing some other SQL in between? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com