Re: Howto retrieve serial field after insert?
After INSERT use:
LET var = DBINFO( "SQLCA.SQLERRD1" );
Danail
----- Original Message -----
From: "Ron M. Flannery" <rflanner@speedlink.net>
To: "Dan Sjuls" <dan.sjuls@paf.fi>
Cc: <informix-list@iiug.org>
Sent: Wednesday, September 27, 2000 1:50 PM
Subject: Re: Howto retrieve serial field after insert?
> > How do I return the data from a serial field after a insert in a stored
> > procedure?
> >
> > insert into table (x_serial) values (0)>
> Well in 4gl, you'd simply use the value of sqlca.sqlerrd[2]; I don't know
> if it's available in a stored procedure. If not, try "select
max(x_serial)
> from table"..
>
>