On 31 Jul 2006 at 17:00, martinknappe wrote:

>CREATE trigger dicentries_bu0 for dicentries
>active before update position 0
>as
>declare variable wanted_id bigint;
>begin
> for select id from dicentries where asverwid = new.id into
> :wanted_id do
> begin
> update dicentries
> set
> asverwterm = new.asterm
> where
> ID = :wanted_id;
> end
>end
>
>does any of you see why it doesnt work?

I don't see why it could not work, but your select-update
construction is completely equal to simple "UPDATE dicentries SET
asverterm=new.asterm WHERE asverwid=new.id". May be it is not what
you had in mind...

--
SY, Dimitry Sibiryakov.