I've posted this previously but received no reply. Thought I;d ask
one more time before reporting it as a bug.


I used:

ISQL -a -user SYSDBA -pas masterkey -o c:\db.sql MyDB

to obtain the ddl from my database, but it contains the following
entries that I don't quite understand:

ALTER TABLE CLIENT_STATUS ADD
AS
begin

if (new.CLIENT_STATUS_ID is null)
then new.CLIENT_STATUS_ID = gen_id(CLIENT_STATUS_GEN, 1);
end;

ALTER TABLE CLIENT_WEB_FORMS ADD
AS
begin
if (new.CLIENT_WEB_FORMS_ID is null)
then new.CLIENT_WEB_FORMS_ID = gen_id(CLIENT_WEB_FORMS_GEN, 1);
end;

ALTER TABLE CONTACT_TYPE ADD
AS begin
if (new.CONTACT_TYPE_ID is null)
then new.CONTACT_TYPE_ID = gen_id(BRANCH_GEN, 1);
end;

These are all before insert triggers. About 50% of my before insert
triggers are listed like this. Any ideas why?

Using FBv1.52 SS

Thanks