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