Subject | Re: [firebird-support] Re: Triggers |
---|---|
Author | Nando Dessena |
Post date | 2007-04-18T15:30:51Z |
Visakan,
copy this *as it is* into FlameRobin's query editor:
SET TERM ^;
CREATE TRIGGER Tri_Area FOR AREA
ACTIVE BEFORE INSERT
AS
BEGIN
new.SEQ = GEN_ID(AREA_NEXTNO,1);
END^
SET TERM ;^
Don't select any part of it and press F4. That should work.
BTW, you might be interested in knowing that FlameRobin has an
auto-increment feature that will create triggers similar to the above
automatically.
Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================
copy this *as it is* into FlameRobin's query editor:
SET TERM ^;
CREATE TRIGGER Tri_Area FOR AREA
ACTIVE BEFORE INSERT
AS
BEGIN
new.SEQ = GEN_ID(AREA_NEXTNO,1);
END^
SET TERM ;^
Don't select any part of it and press F4. That should work.
BTW, you might be interested in knowing that FlameRobin has an
auto-increment feature that will create triggers similar to the above
automatically.
Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================