After I changed this as below, this works!

CREATE PROCEDURE P_UPD_RENTA
AS/**/
declare variable ibsnr integer;
declare variable iarbkrenta double precision;
declare variable iteilenr varchar(8);
BEGIN
for select bsnr, teilenr, arbkostenrenta from tarbg where
(((upper(arbeitsgang) not containing 'SCHWEIEN')
and(upper(arbeitsgang) not containing 'SCHWEISSEN')) and arbkostenrenta >
0)
into :ibsnr, :iteilenr, :iarbkrenta do
begin
iarbkrenta = iarbkrenta / 10.9 * 12.4;
update tarbg set arbkostenrenta = :iarbkrenta where teilenr = :iteilenr
and
bsnr = :ibsnr;
end
END

I'm using firebird 2.1 cs and ems interbase/firebird manager.

Thank you.

Best regards.

Olaf

sorry, on my second text there is missing the character ß, so I mean “not
containing ‘SCHWEIßEN”. The first text of the procedure I have corrected,
but I have forget it in the second. In my local area it is right, it is only
a copy and paste problem in this email. At the moment I have no solution for
this problem. Only procedure variant 2 works well.



Thanks



[Non-text portions of this message have been removed]