I believe you need to call your function the following way:
FOREACH
Call function(parameters) returning x,y;
do some more stuff
return y,z
END FOREACH
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
On Behalf Of Kennedy, Randy
Sent: Monday, October 11, 2004 9:20 AM
To: informix-list@iiug.org
Subject: function in foreach loop
I have a function that uses a return with resume to return 2 columns and
usually between 2 and 7 rows. I now want to use this function in a
foreach
loop in another function to use each returned value in additional
processes.
I keep getting syntax errors with the following style code:
FOREACH
Let x,y =3D function(parameters);
do some more stuff
return y,z
END FOREACH
x,y, and z have all been defined.
Is this supported? IDS 9.4FC3 on HPUX11i
TIA,
Randy
sending to informix-list
sending to informix-list