I think you forgot many things, if I undestood your question, you must have
something like:

Try to replace this code:

> While T2.F2=:variable do
> begin
> set T2.F3=:sum
> end
> suspend;
> end

with this code:

FOR SELECT (PutSomeKeyIdHere) FROM T2 WHERE T2.F2=VARIABLE INTO :xx DO
UPDATE T2 SET F3=:sum WHERE UseTheKeyIdHereAgain=:xx

Artur Anjos

----- Original Message -----
From: "KURSAT TASKIN" <kursatt@...>
To: "Ib-Support (E-mail)" <ib-support@yahoogroups.com>
Sent: Monday, December 10, 2001 8:11 AM
Subject: [ib-support] Loop Problems and referencing to other tables