new.field is the answer


thanks



Maurizio ha scritto:

> 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
>
>
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>
>