Re: Return values ???

With this way, I have compilation error -4373 ... Octav Chiriac wrote: > 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