Dimitry Sibiryakov wrote:

>> and of course it affected all the rows , bu i want update only
>> the inserted row
>>
>> any help ?
>
> Use before insert trigger and assign new value to :NEW.FIELD.

You meant: to NEW.FIELD

Regards,

--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com