Maurizio wrote:

> hi ,
> i have to update a field of a table when a new record of the same table
> is inserted .
>
> i am tryng to use an after insert trigger , i tryed
>
> ..
> update test_table s
> set s.kyriga = 'test' ;
> ..
>
> and of course it affected all the rows , bu i want update only
> the inserted row
>
> any help ?
>
>
> thanks
>
> Maurizio

NEW.kyriga = 'test'

http://www.firebirdsql.org/refdocs/langrefupd20-create-trigger.html

Uwe