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?

Thanks.

RT;

<<< 6.12.2016 9:23 - Dmitry Yemanov dimitr@... [firebird-support] "firebird-support@yahoogroups.com" >>>
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> Check RDB$GENERATOR_INCREMENT inside RDB$GENERATORS. NEXT VALUE FOR uses
DYdusnfs> the increment stored inside the system table.


DYdusnfs> Dmitry




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

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

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

DYdusnfs> Visit http://www.firebirdsql.org 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> http://www.ibphoenix.com/resources/documents/

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

DYdusnfs> Yahoo Groups Links








--
Best regards, TRoland
http://www.rotursoft.sk
http://exekutor.rotursoft.sk