Subject Re: [firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit
Author Roland Turcan
Hello Dmitry,

Thanks for response, but I have found that he has only few generators
with value 1.

But I cannot call this:

update RDB$GENERATORS set rdb$generator_increment = 1 where rdb$generator_name not starting 'RDB$';

how can I set the value to 1?



<<< 6.12.2016 9:23 - Dmitry Yemanov dimitr@... [firebird-support] "" >>>
DYdusnfs> 06.12.2016 11:05, Roland Turcan wrote:
>> I have installed new clean database to new customer having FB3.0.1
>> 32bit running on Windows7Pro 32bit. He was complaining that he is not
>> able to add new record into some parts of our software. I have
>> connected to his computer and made backup/restore and aligned all
>> generators to MAX(ID) to be sure they are correct. But he still had
>> some troubles then I started to investigate what the hell is going on.
>> I have found, that on his "server" is NEXT VALUE FOR not incrementing
>> generator value, but places where GEN_ID is used instead are working
>> fine.
>> I have tried to reproduce this on 32bit XP with the same version of
>> FB, but in my case it was running fine.
>> Does anybody have this kind of trouble?

DYdusnfs> the increment stored inside the system table.

DYdusnfs> Dmitry

DYdusnfs> ------------------------------------

DYdusnfs> ------------------------------------

DYdusnfs> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

DYdusnfs> Visit and click the Documentation item
DYdusnfs> on the main (top) menu. Try FAQ and other links from the left-side menu there.

DYdusnfs> Also search the knowledgebases at

DYdusnfs> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
DYdusnfs> ------------------------------------

DYdusnfs> Yahoo Groups Links

Best regards, TRoland