Subject | GEN_ID: trigger does not seem to fire |
---|---|
Author | macquarietc@yahoo.com |
Post date | 2001-08-02T00:45:26Z |
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.
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.