Subject | Re: [firebird-support] Need advice |
---|---|
Author | constantijnw |
Post date | 2005-10-21T08:36:50Z |
jasajona wrote:
CREATE TRIGGER SETTBL2FLD2 FOR TABLE1
AFTER
INSERT
AS
BEGIN
INSERT INTO TABLE2 (FIELD2) VALUES (NEW.FIELD1);
END
> Hello,You mean something like this?
>
> 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 .
>
CREATE TRIGGER SETTBL2FLD2 FOR TABLE1
AFTER
INSERT
AS
BEGIN
INSERT INTO TABLE2 (FIELD2) VALUES (NEW.FIELD1);
END