> If somebody could just help me with the sql for it, I could do it
> myself, but I don't know firebird ddl/sql that well.

DDL:

CREATE GENERATOR <generator name>;

DML

SELECT gen_id(<generator name>, <inc factory>) FROM rdb$database

Roman