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 [email protected] [firebird-support] "[email protected]" >>> 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
