beginner procedure problem
I managed to create a procedure that does the work expected
and it returns the data I want. The problem is that I can't
access the data. When I run the procedure (in dbaccess) I get this:
(expression) 10
(expression) 11
(expression) GENERALTULL
(expression) 8802
(expression) 180.0000000000
(expression) 180.0000000000
(expression) X
This is what I want but I'd like to assign names to the data
and be able to insert it into a temp table.
EXECUTE PROCEDURE foreach_test() INTO TEMP foo;
or somthing like this.
Pointers to resources and faq also wanted.
Thanks in adwance...
Peter
The procedure is below.
drop procedure foreach_test;
create procedure foreach_test()
returning int foo, int, char(15), int, float, float, char(1);define site, branch, volgnr int;
define p_vstnr_filnaam, p_filnr_filnaam, p_akti_nummer int;
define p_bedrag_verkoop, p_bedrag_inkoop float;
define p_zoek_supplzd char(15);
define p_x_bedrag char;
foreach
select vstnr_filnaam, filnr_filnaam, volg_nr volgnr
into site, branch, volgnr
from zendalg
where vstnr_filnaam = 10
and filnr_filnaam = 11
and afdnr_afdtabel = 2
and shipment_date between '990101' and '991231'
foreach
select vstnr_filnaam ,filnr_filnaam, zoek_supplzd,
akti_nummer, bedrag_verkoop, bedrag_inkoop,
x_bedrag
into p_vstnr_filnaam ,p_filnr_filnaam, p_zoek_supplzd,
p_akti_nummer, p_bedrag_verkoop, p_bedrag_inkoop,
p_x_bedrag
from supplzdr
where vstnr_filnaam = site
and filnr_filnaam = branch
and vlgnr_zendalg = volgnr
return p_vstnr_filnaam ,p_filnr_filnaam, p_zoek_supplzd,
p_akti_nummer, p_bedrag_verkoop, p_bedrag_inkoop,
p_x_bedrag with resume;
end foreach
end foreach
end procedure ;