At 10:22 AM 16/11/2005 +0000, tickerboo wrote:

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

It looks like a bug to me. Would you please repost to firebird-devel.

When you report it, make certain that you include details of the exact
build *number* and platform.

./heLen

>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