Re: [firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit

2016-12-28 Thread Roland Turcan k...@rotursoft.sk [firebird-support]
<<< 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

[firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit

2016-12-21 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
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

Re: [firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit

2016-12-21 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
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

Re: [firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit

2016-12-21 Thread Roland Turcan k...@rotursoft.sk [firebird-support]
<<< 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

Re: [firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit

2016-12-21 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
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

Re: [firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit

2016-12-21 Thread Roland Turcan k...@rotursoft.sk [firebird-support]
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 -

[firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit

2016-12-06 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
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

Re: [firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit

2016-12-06 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
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-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit

2016-12-06 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
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