| Subject | Re: [firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit |
|---|---|
| Author | Helen Borrie |
| Post date | 2016-12-21T20:53:11Z |
Hello Roland,
Wednesday, December 21, 2016, 10:39:50 PM, Roland Turcan wrote:
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
Wednesday, December 21, 2016, 10:39:50 PM, Roland Turcan wrote:
> But still, why this problem occurred? Why didn't some generators haveA generator that has never been triggered has a value of 0, not 1.
> it =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