Devart Forums

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

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.

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

Sorry....IBDAC Version should read 3.50.0.21.

IBDAC doesn't show system generators. You can check if your generators have system flag by executing the following SQL code:Generators that have RDB$SYSTEM_FLAG = 1 aren't shown in the list (when you are using the KeyGenerator property).

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

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.