I have been trying to create a trigger without any luck and was hoping
someone might have some idea what i am doing wrong.

my table has the field tripid integer not null primary key.
my generator is autonumber.
when I try:
set term !!;
create trigger i_tripid for trip
active before insert
as
begin
if(new.tripid is null)
then
new.tripid = gen_id(autonumber,1);
end
set term ;!!

I get the error response:
SQL error code = -104
Token unknown - line 9, char 1
set

my trigger is not created and my line terminator is in fact !! not ;.

Thanks in advance

---
Paul


[Non-text portions of this message have been removed]