Firebird 3 RC: Set Generator

[ralle1]

Dear Devart Team,

I upgraded a database to the firebird 3 release candidate. The following example code triggers an exception:
"SQL information exception"

Code: Select all

  IBCQuery1.SQL.Text := 'SET GENERATOR GEN_TEST TO 0';
  IBCQuery1.ExecSQL;

Do you know something about this topic?
The generator exists and the same code runs with Firebird 2.1/2.5 without problems.

I am using: IBDAC 4.5.9 for Delphi XE2

Thank you very much for an answer.

[ralle1]

I just updated IBDAC to the following version: IBDAC 5.6 for RAD Studio XE2
The problem is still there. I'm looking forward to your feedback.

[ViktorV]

Thank you for the information. We have reproduced the problem and investigation is in progress. We will inform you when we have any results.
As a workaround, you can set the TIBCQuery.Options.QueryRowsAffected option to False.

[ralle1]

Hello Viktor,

Is there meanwhile a solution for the problem?

[ViktorV]

Fix for the bug with executing a SET GENERATOR statement in Firebird 3 was included in IBDAC 5.6.21.