Antw: Re: Howto retrieve serial field after insert?
Hello,
in an stored procedure it's possible like this:
let serialvalue = dbinfo("sqlca.sqlerrd1");
Martin
>>> "Ron M. Flannery" <rflanner@speedlink.net> 27.09.00 12:50 >>>
> 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"..