Page 1 of 1

Firebird ExecuteQueryPrepared not using AutoCommit

Posted: 07.08.2015, 14:21
by qbitza
Hi guys,

I'm experiencing a bit of an issue with the Firebird driver.

We're executing a stored procedure that returns a value, and for some rhyme or reason the transaction is not being committed.

I've traced it to TZInterbase6PreparedStatement.ExecuteQueryPrepared which seems to be oblivious to autocommit.

For instance TZInterbase6PreparedStatement.ExecutePrepared contains:

Code: Select all

      { Autocommit statement. }
      if Connection.GetAutoCommit then
        Connection.Commit;
Is the fact that ExecuteQueryPrepared omits this by design, a bug or am I missing something?