Hi,

I can see there's a lot of business logic to set ang_preis and than vkpreis.

So... I believe your problem resides on this logic... I'm sure if you had
something like:

create trigger...
begin
new.vkpreis = 1234;
end
^

vkpreis would been set acordingly.

So, what *I think* you need is to "debug" your trigger code against the
actual values of the updated record and on the involved tables/selects.


Regards,
Anderson Farias