Subject Re: [firebird-support] tricky trigger
Author Dimitry Sibiryakov
On 31 Jul 2006 at 17:00, martinknappe wrote:

>CREATE trigger dicentries_bu0 for dicentries
>active before update position 0
>declare variable wanted_id bigint;
> for select id from dicentries where asverwid = into
> :wanted_id do
> begin
> update dicentries
> set
> asverwterm = new.asterm
> where
> ID = :wanted_id;
> 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". May be it is not what
you had in mind...

SY, Dimitry Sibiryakov.