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;