Re: [firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit
<<< 22.12.2016 7:20 - Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] "firebird-support@yahoogroups.com" >>> DYdusnfs> 21.12.2016 12:39, Roland Turcan wrote: >> >> But still, why this problem occurred? Why didn't some generators have >> it =1? DYdusnfs> Could that database be migrated from some pre-release (e.g. Beta) v3 DYdusnfs> build without backup/restore? Dmitry, I used an empty database made with backup/restore from 2.5.6 to 3.0.1. I did this step many times and this is the only one with this issue. I will inform you, when this happens again. -- Best regards, TRoland http://www.rotursoft.sk http://exekutor.rotursoft.sk
[firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit
21.12.2016 12:39, Roland Turcan wrote: > > But still, why this problem occurred? Why didn't some generators have > it =1? Could that database be migrated from some pre-release (e.g. Beta) v3 build without backup/restore? 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: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit
Hello Roland, Wednesday, December 21, 2016, 10:39:50 PM, Roland Turcan wrote: > But still, why this problem occurred? Why didn't some generators have > it =1? A generator that has never been triggered has a value of 0, not 1. In the context of your complaint that NEXT VALUE FOR seemed to return a wrong value, Dmitry suggested you query the column RDB$GENERATOR_INCREMENT in RDB$GENERATORS, to check whether the problem might be caused by 0 or null in that field. If you didn't do that, and you think you still have a problem, then look at it. HB
Re: [firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit
<<< 21.12.2016 9:34 - Helen Borrie hele...@iinet.net.au [firebird-support] "firebird-support@yahoogroups.com" >>> HBhinafs> Hello Roland, HBhinafs> HBhinafs> Wednesday, December 21, 2016, 9:11:36 PM, Roland Turcan wrote: HBhinafs> >> But I cannot call this: HBhinafs> >> update RDB$GENERATORS set rdb$generator_increment = 1 where >> rdb$generator_name not starting 'RDB$'; HBhinafs> HBhinafs> System Tables are read-only in Fb 3. HBhinafs> >> how can I set the value to 1? HBhinafs> HBhinafs> Read the release notes, page 71 (pdf page 81) and all will be HBhinafs> revealed. (On-line: HBhinafs> HBhinafs> http://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-ddl-enhance.html#rnfb30-ddl-altersequence HBhinafs> HBhinafs> HB Thanks Helen, I haven't known that this DDL command exists in that form to manipulate it. But still, why this problem occurred? Why didn't some generators have it =1? -- Best regards, TRoland http://www.rotursoft.sk http://exekutor.rotursoft.sk
Re: [firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit
Hello Roland, Wednesday, December 21, 2016, 9:11:36 PM, Roland Turcan wrote: > But I cannot call this: > update RDB$GENERATORS set rdb$generator_increment = 1 where > rdb$generator_name not starting 'RDB$'; System Tables are read-only in Fb 3. > how can I set the value to 1? Read the release notes, page 71 (pdf page 81) and all will be revealed. (On-line: http://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-ddl-enhance.html#rnfb30-ddl-altersequence HB
Re: [firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit
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 dim...@users.sourceforge.net [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
[firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit
06.12.2016 11:50, Mark Rotteveel wrote: > I noticed something interesting, when restoring a Firebird 2.5 database > to Firebird 3.0, only user generators (RDB$SYSTEM_FLAG = 0) get a value > of 1 in RDB$GENERATOR_INCREMENT, system generators get 0. Is that > intentional? System generators are not transferred in backup, they're recreated from scratch when a database is being created during restore. And you cannot explicitly issue either GEN_ID or NEXT VALUE for them, the engine itself increments them at the low level, without looking at RDB$GENERATOR_INCREMENT. So I believe it's absolutely OK, although possibly looking weird. Dmitry
Re: [firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit
On 6-12-2016 09:23, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote: > Check RDB$GENERATOR_INCREMENT inside RDB$GENERATORS. NEXT VALUE FOR uses > the increment stored inside the system table. I noticed something interesting, when restoring a Firebird 2.5 database to Firebird 3.0, only user generators (RDB$SYSTEM_FLAG = 0) get a value of 1 in RDB$GENERATOR_INCREMENT, system generators get 0. Is that intentional? Mark -- Mark Rotteveel
[firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit
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: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/