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.
