Re: Return values ???

DECLARE qCursorName CURSOR FOR "EXECUTE PROCEDURE theprocedure(?,?)" OPEN qCursorName USING var1, var2 WHILE TRUE FETCH qCursorName INTO result1, result2 IF sqlca.sqlcode == NOTFOUND THEN EXIT WHILE END IF -- DO SOMETHING WITH YOUR results END WHILE CLOSE qCursorName FREE ... stuff Of course if you know the procedure will return only one result set you can exclude the while loop and use just one FETCH. And to return more than one result set your procedure should return values WITH RESUME. Hope this helps, Octav On Mon, Aug 09, 1999 at 04:07:53PM +0800, Wu wrote: > How to accept the return values from a stored procedure in i4gl module ? > Appreciate if example is given. thanx. > > -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com