Page 1 of 1

Firebird 3 RC: Set Generator

Posted: Fri 08 Jan 2016 13:35
by 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.

Re: Firebird 3 RC: Set Generator

Posted: Mon 11 Jan 2016 10:02
by 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.

Re: Firebird 3 RC: Set Generator

Posted: Mon 11 Jan 2016 11:27
by 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.

Re: Firebird 3 RC: Set Generator

Posted: Thu 09 Jun 2016 11:26
by ralle1
Hello Viktor,

Is there meanwhile a solution for the problem?

Re: Firebird 3 RC: Set Generator

Posted: Thu 09 Jun 2016 12:43
by ViktorV
Fix for the bug with executing a SET GENERATOR statement in Firebird 3 was included in IBDAC 5.6.21.