InterBase Autoinc Tutorial - Why did they not build this into InterBase?
Brief tutorial on how to implement an autoinc, or identity, field into your InterBase database(s). It's simple enough so why didn't they do this years ago?
SQL script to create generator and trigger:
CREATE GENERATOR gen_NextID;
SET GENERATOR gen_NextID to 0;
CREATE TRIGGER clients_autoid FOR testautoinc
BEFORE INSERT AS
BEGIN
IF ((NEW.id is NULL) or (NEW.id = -1)) THEN
NEW.id = GEN_ID(gen_NextID, 1);
END;