Subject | FB2 and Triggers. |
---|---|
Author | Michael Vilhelmsen |
Post date | 2006-11-22T08:44:47Z |
Hi
As I can read in the release notes somewhere I cannot create a trigger
like this in FB2.
CREATE TRIGGER EKSP_DEL_RETTIG FOR EKSPEDIENTER ACTIVE AFTER DELETE
POSITION 0 AS
begin
Delete from Eksp_Maa Where EkspID=EKSPEDIENTER.NR;
end
This was posible in FB 1.5.3.
My question is:
I have running databases on FB1.5 that have a trigger like this.
I can make a backup in FB1.5 and then do a restore in FB2 with the
above trigger it works. The DB gets restored. And the trigger gets
fired and does its work (eventhough the syntax is wrong)
The new FB2 DB has the above trigger. I can't alter it, without
changing it to (Ekspedienter.NR --> OLD.NR):
CREATE TRIGGER EKSP_DEL_RETTIG FOR EKSPEDIENTER ACTIVE AFTER DELETE
POSITION 0 AS
begin
Delete from Eksp_Maa Where EkspID=OLD.NR;
end
So a trigger created in FB15, backed up, restored in FB2 with a wrong
syntax will work ?
Michael
As I can read in the release notes somewhere I cannot create a trigger
like this in FB2.
CREATE TRIGGER EKSP_DEL_RETTIG FOR EKSPEDIENTER ACTIVE AFTER DELETE
POSITION 0 AS
begin
Delete from Eksp_Maa Where EkspID=EKSPEDIENTER.NR;
end
This was posible in FB 1.5.3.
My question is:
I have running databases on FB1.5 that have a trigger like this.
I can make a backup in FB1.5 and then do a restore in FB2 with the
above trigger it works. The DB gets restored. And the trigger gets
fired and does its work (eventhough the syntax is wrong)
The new FB2 DB has the above trigger. I can't alter it, without
changing it to (Ekspedienter.NR --> OLD.NR):
CREATE TRIGGER EKSP_DEL_RETTIG FOR EKSPEDIENTER ACTIVE AFTER DELETE
POSITION 0 AS
begin
Delete from Eksp_Maa Where EkspID=OLD.NR;
end
So a trigger created in FB15, backed up, restored in FB2 with a wrong
syntax will work ?
Michael