Subject | intermediate messages from a query |
---|---|
Author | Peppe Polpo |
Post date | 2003-09-11T21:25:10Z |
please look this code:
create procedure test
returns
(cmessage varchar(20)
as
begin
for select id_emp from tb_emp do
begin
cmessagge='employee ' || id_per || ' is being processed';
suspend;
/*some action*/
end
end
only _at the end_ of the query I get the messages _all together_,
what is completely unuseless to me.
No way to get what I want ?
regards
Peppe Polpo
create procedure test
returns
(cmessage varchar(20)
as
begin
for select id_emp from tb_emp do
begin
cmessagge='employee ' || id_per || ' is being processed';
suspend;
/*some action*/
end
end
only _at the end_ of the query I get the messages _all together_,
what is completely unuseless to me.
No way to get what I want ?
regards
Peppe Polpo