..
update test_table s
set s.kyriga = 'test'
where old.target=s.target;
..

--- On Sat, 3/14/09, Maurizio <mauriz_po@...> wrote:
From: Maurizio <mauriz_po@...>
Subject: [firebird-support] update a field in after insert update
To: firebird-support@yahoogroups.com
Date: Saturday, March 14, 2009, 9:21 AM

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








[Non-text portions of this message have been removed]