Devart Forums

hello

create procedure like this:

DELIMITER $$

drop PROCEDURE if exists getsum_sp$$

CREATE PROCEDURE getsum_sp(in a1 int, in a2 int, out A int)
BEGIN

Set A = a1 + a2;
END$$

DELIMITER ;

create a new c++ project and new TMyStoredProc with StoredProcName = 'getsum_sp'

doppel click the component:
1) under mariadb 10.5.8-MariaDB
the sql is: CALL getsum_sp(:a1, :a2, @A); SELECT CAST(@A AS SIGNED) AS '@A'
and the parameters that return are correct.

2) under mysql 5.0.45-community-nt:
the sql is: CALL getsum_sp()
and the parameters that return are not correct.

please help

Thank you for the information. We have reproduced and fixed the issue. This fix will be included in the next build of MyDAC.
We can send you the nigthly build that include the necessary changes.
Please provide your license number and IDE version to us using the contact form https://devart.com/company/contactform.html and we will send you a night build.