How to use the Firebird 3 Identity columns?

[danielrail]

Hi,

I'm using Delphi XE7, IBDAC 7.1.2 and Firebird 3.0.4.

I just created a new database with Firebird 3.0.4 and decided to use the new IDENTITY columns, as primary key columns, instead of the generators and insert triggers. But, IBDAC query and/or table components are expecting a value for those fields before performing the insert statement.

I did see in the forum that there was mention that the work was started back in 2014, but after looking through the release notes, there is no mention of the support for the IDENTITY columns.

Is there a way to make IBDAC work with IDENTITY columns in Firebird 3?

[danielrail]

After a little bit more digging I found my answer.

I simply needed to set the Options.RequiredFields to False, and it now works as expected.

[ViktorV]

We are glad to hear that you have found a solution of the issue.
If you have any questions during using our products, please don't hesitate to contact us - and we will try to help you solve them.