Adam wrote:

create procedure copythis
as
begin
for
select q, y
from b
into :q, :y
do
begin
update a set p = :q where x = :y;
end
end


if there are 100 rows selected by query inside for .... do,
will the statement " update a set p = :q where x = :y; " be
iterated for 100 times or executed only once?

regards,
bill