Re: Return values ???

Could you post the 4gl .err file fragment with the indication of what is wrong. On Mon, Aug 09, 1999 at 04:56:58PM +0800, Wu wrote: > 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 > -- 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