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?
Check RDB$GENERATOR_INCREMENT inside RDB$GENERATORS. NEXT VALUE FOR uses the increment stored inside the system table. Dmitry ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
