TIBCQuery....Keygenerator

bzwirs · Post by **bzwirs** » Fri 15 Apr 2011 00:58

Hi,

Delphi 2010, firebird database.

I am using a TIBCQuery for update, insert etc. The database contains 21 generators but the KeyGenerator property of the TIBCQuery component only lists eight of them.

Help please.

regards

Bill

AndreyZ · Post by **AndreyZ** » Fri 15 Apr 2011 13:30

Hello,

I cannot reproduce the problem. Please specify the following:
- the exact version of IBDAC. You can learn it from the About sheet of TIBCConnection Editor;
- the exact version of Firebird. You can learn it from the Info sheet of TIBCConnection Editor.
Also please try using the latest version of IBDAC 3.50.0.21, and check if the problem persists.

bzwirs · Post by **bzwirs** » Sat 16 Apr 2011 02:55

Hi,

IBDAC Version 30.50.21

Firebird :

Server Version: WI-V2.5.0.26074 Firebird 2.5
Client Version: 6.3
ODS Version: 11.0
Client Library: gds32.dll
Database SQL Dialect: 3

Even though the generators are not all listed, I can enter a value not listed in the property and a KeyFields property value and it works Ok. Just would be nice to simply select the KeyGenerator property value from the list.

I am in the process of converting this project from IBX to IBDAC. Used the Migration Wizard. Would be good if the Migration Wizard could have done this part (Keygenerators and KeyFields) during the conversion.

regards

Bill

bzwirs · Post by **bzwirs** » Sat 16 Apr 2011 08:47

Sorry....IBDAC Version should read 3.50.0.21.

AndreyZ · Post by **AndreyZ** » Mon 18 Apr 2011 10:48

IBDAC doesn't show system generators. You can check if your generators have system flag by executing the following SQL code:

Code: Select all

SELECT * FROM RDB$GENERATORS

Generators that have RDB$SYSTEM_FLAG = 1 aren't shown in the list (when you are using the KeyGenerator property).

bzwirs · Post by **bzwirs** » Tue 19 Apr 2011 00:27

Ok. Just used IBExpert to look at the RDB$GENERATORS table and the generators that are not showing all have a NULL RDB$SYSTEM_FLAG value.

Not sure how that would have happened! Maybe when converting to different versions of Firebird over the years.

regards

Bill

bzwirs · Post by **bzwirs** » Tue 19 Apr 2011 00:48

A backup and restore of the database has fixed the problem. The copy of the clients database was Firebird Version 2.1 and the version on my development machine is 2.5.

Thanks. All's well with the world again.