RE: Serials and Stored procedures

Posted in 2000

Demus, Alan — Thu, 17 Feb 2000 09:59:59 -0600 — source: Informix-list mailing list archive (1991-1998)

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 >