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