Subject | Re: [firebird-support] Re: update from 2 tables |
---|---|

Author | bill_lam |

Post date | 2006-06-23T10:09:26Z |

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

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