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 dimitr@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

__._,_.___

---

Posted by: Roland Turcan <konf@rotursoft.sk>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___