You don't have to do a SELECT, just
let l_result = dbinfo('sqlca.sqlerrd1');
(Still kinda silly, but not too egregious)
> -----Original Message-----
> From: Paul Harman [SMTP:paul@kasterborus.demon.co.uk]
> Sent: Thursday, February 17, 2000 8:53 AM
> To: informix-list@iiug.org
> Subject: Serials and Stored procedures
>
> Firstly, can anyone recommend a good SPL reference manual, so I don't have
> to ask these silly questions? };*)
>
> What is the best way to acquire the serial value that the INSERT you just
> performed created, while inside a stored procedure? I can't believe you
> have
> to do the SELECT DBINFO nonsense, there are ways around it in all the
> other
> programming languages I've used - or is that just because they've done
> this
> call "behind my back"? Besides, what if someone else gets in there first
> with an insert before I do my select?
>
> Paul
>