Re: Calling Stored Proceedures in 4GL

Jackson Thompson wrote: > > pardon a newbie question, > > once I've created a stored procedure that returns a single value, how do > I call it from within 4gl > > Oh, we are on informix-se 7.1 using rapid development system. You need to PREPARE the EXECUTE PROCEDURE statement, then DECLARE a cursor, OPEN it and FETCH the returned values INTO your program variables. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+