Hi folks,

Has anything changed with regard to generators after Firebird 1.5?
I've got Helen Borrie's first version as my reference book, and in
there I read

SELECT GEN_ID(<name>,<step>) FROM RDB$DATABASE;

as the way to increment the value returned from a generator.

I guess I should say now that I'm using the embedded server v2.5.2
from Lazarus/FreePascal under 64-bit Debian.

Everything else seems to be working, I can create the database, the
tables, the indices, all works fine, but when I try to return values
from the generator it never increments. I can vary the value returned
by varying the step, but it's always returning (1+step) no matter how
many calls I make to the routine. Does anybody have any idea what I'm
missing, please?

Thanks,

Brian.