Devart Forums

Hello,

in IBDAC Version 7.3.2 with Delphi 10.4.1 Sydney is a new error: Incorrect values within SQLDA structure

In IBDAC Version 7.1.3 with Delphi 10.3.3 Rio it works fine.

In Unit IBCClasses.pas the result of variable RES = 0 in Version 7.1.3
and
in the new IBDAC-Version 7.3.2 the result of RES = 335544569

To reproduce the error:
Take a TIBCStoredProc
Take on Database Procedure with a Inputparameter of TYPE INTEGER
Example:
CREATE PROCEDURE MYPROCEDURE(
MYID INTEGER)
AS
DECLARE S1 VARCHAR(10);
BEGIN
S1 = 'Say Hello';
END

IB_StoredProc1.StoredProcName := 'MYPROCEDURE';
IB_StoredProc1.prepare;
IB_StoredProc1.ParamByName('MYID').AsString := '2';
IB_StoredProc1.Execute;

I hope, the error will be find fast, because we Update Delphi, Komponents an our custom projects and now our customer are waiting.

Thanks for a quick help
Gerd (from Germany)

Hello,
Thank you for the information. We've reproduced the issue and are currently working to resolve it. We'll keep you updated on the progress.

wbr, Oleg
Devart Team

Hello,
We've fixed the issue. The change will be included in the next release. If you urgently need the fix, we can send you the nightly build. If so, please send us your IBDAC license number, using the form: https://devart.com/company/contactform.html

wbr, Oleg
Devart Team

Hello,

Thank you for the good news.
When will the new version of IBDAC and UniDAC be released, since I have both licensed packages installed and there are version conflicts when I update only IBDAC?
If it is still this week, then I can wait.

Best regards from Germany

Hi Gerd,

Sorry for the confusion in previous post reply.
Please note that the fix was already included into last build IBDAC 7.4.3 available for download from April 6th 2021.
All of the DAC products are based on the same core codebase, therefore, compatible versions of data access components should be installed in the same IDE, as indicated on the Compatibility pages, e.g. (https://www.devart.com/mydac/compatibility.html).
As a result, we advise you while updating one of DAC products you need to update all other DAC products used for this IDE.

Kind regards,
Viktor

Hello,

unfortunately the bug persists in IBDAC version 7.4.3 dated 6 April 2021.

My last answers already referred to this version 7.4.3.
Now I just checked it again.
The transaction error is still present with my example sent to them.
I need a solution here urgently.
Thank you very much.

Best regards from Germany

Kindly note that our reply on forum was related to "Incorrect values within SQLDA structure".
Please be informed that the issue related to “invalid transaction handling” is currently being at work by our team. Once we have the resolution, we will immediately let you know.

Best regards,
Viktor

Hi there!

Hope you are doing fine!
Kindly be informed that this bug has been fixed.
The fix was also implemented in the current release IBDAC 7.4.4, which is already available for download!
Let us know if there are any questions.

Regards,
Viktor