Subject GEN_ID: trigger does not seem to fire
Author macquarietc@yahoo.com
I have created a Generator and the Trigger and they both exist in the
database.

CREATE GENERATOR UNIGEN;

SET TERM !! ;
CREATE TRIGGER UNIKEY FOR UNIVERSAL
BEFORE INSERT POSITION 0
AS BEGIN
NEW.KEYNO = GEN_ID(UNIGEN, 1);
END !!
SET TERM ; !!

The problem is when I insert the record the 'KEYNO' is NULL. I am
using IBX components in Delphi v5 enterprise.

tUniversal.Insert;
tUniversal['fName'] := 'BOB';
tUniversal.Post;

I hope someone will assist me with this problem.

John Hart.