Subject Re: [firebird-support] Re: Triggers
Author Nando Dessena
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
======================================================