Helen,
Thank you for help, I should have read more careful the explaination
of how to use triggers.

On Sat, 25 Dec 2004 11:24:15 +1100, Helen Borrie <helebor@...> wrote:
> At 05:26 PM 24/12/2004 -0500, you wrote:
>
> >Dynamic SQL Error
> >-SQL error code = -206
> >-Column unknown
> >-PERSON.ID
> >-At line 5, column 13.
> >make: *** [/home/taf2/simo2/debug/bin/simo.fdb] Error 1
> >
> >
> >SET TERM !!;
> > CREATE TRIGGER person_generator FOR person
> > ACTIVE BEFORE INSERT POSITION 0
> > AS
> > BEGIN
> >/* IF (person.id IS NULL) THEN */
>
> IF (NEW.id IS NULL) THEN
>
> >/* person.id = GEN_ID(person_seq,1); */
>
> new.id = GEN_ID(person_seq,1);
>
> > END!!
> >SET TERM ;!!
> >
> >-- Commit Changes
> >--------------------------------------------------------------
> >commit;
>
> ./hb
>