> Hello,
>
> This is the before insert trigger generated:
>
> CREATE TRIGGER TBLBUILDING_BI FOR TBLBUILDING
> ACTIVE BEFORE INSERT POSITION 0
> AS
> BEGIN
> IF (NEW.TBLBUILDINGID IS NULL) THEN
> NEW.TBLBUILDINGID = GEN_ID(,1);
> END
>
> I think it lacks the field in the GEN_ID params, but I'm not
> sure!!!!
>
> Plus, would this thing work also with the embedded version of firebird?
>
> TIA,
>
> Andrew

You need to select (in IBExpert) whether you want to create a generator on
the fly or use an existing one - the code generated in the absence of this
selection is as you have it. Use the other tabs to get the generator name or
create one.
And yes it will work the same in the embedded server.
Alan