Subject Re: [firebird-support] Need advice
Author constantijnw
jasajona wrote:

> Hello,
>
> What would be best way to add value to a field in trigger? I have
> table1 with float
> field1. When I insert record in to table1 I need to add field1 value
> to table2.field2 .
>
You mean something like this?

CREATE TRIGGER SETTBL2FLD2 FOR TABLE1
AFTER
INSERT
AS
BEGIN
INSERT INTO TABLE2 (FIELD2) VALUES (NEW.FIELD1);
END