--- In firebird-support@yahoogroups.com, "jasajona" <jon@o...> wrote:

>
> Something like this:
>
> CREATE TRIGGER SETTBL2FLD2 FOR TABLE1
> AFTER
> INSERT
> AS
> BEGIN
> INSERT INTO TABLE2 (FIELD2) VALUES (NEW.FIELD1+OLD.FIELD2);
> END
>
> How to do it right and fastest for execution?
>

Not quite sure what your question is.

It wont work because you can not use "OLD" in an insert trigger. There
is no old value unless you are updating or deleting a record.

Adam