Dênis Mendes wrote: > set generator X to (select max(codigo) from tabela_x); select gen_id(X, (select max(codigo) from tabela_x) - gen_id(X, 0)) from RDB$DATABASE -- BigWings "You're not thinking fourth dimmensionally"