TUniStoredProc fails when connection has parameters
Hi,
I have simple UniStoredProc it works fine if I don't define any parameters to connection.
But when I add 2 parameters to uniconnection
UniConnection1.macros.Add('false','0');
UniConnection1.macros.Add('true','1');
I get error
[Zen][ODBC Client Interface][LNA][Zen][SQL Engine]Syntax Error: {:<< ??? >>:RETURN_VALUE = call GetMinPrice30Days(::pvm, ::tuote, ::myymala)}
* without connection parameters *
UniStoredProc1: 15.10.2024 18.35.01 0,000 SQL Execute: {::RETURN_VALUE = call GetMinPrice30Days(::pvm, ::tuote, ::myymala)}
::RETURN_VALUE(Float,RESULT)=<NULL>
::pvm(DateTime,IN)=15.10.2024 18.35.01
::tuote(String[2],IN)='22'
::myymala(Integer,IN)=2 Complete
* without connection parameters *
UniStoredProc1: 15.10.2024 18.35.49 0,000 SQL Execute: {::RETURN_VALUE = call GetMinPrice30Days(::pvm, ::tuote, ::myymala)}
::RETURN_VALUE(Float,RESULT)=<NULL>
::pvm(DateTime,IN)=15.10.2024 18.35.49
::tuote(String[2],IN)='22'
::myymala(Integer,IN)=2Error: [Zen][ODBC Client Interface][LNA][Zen][SQL Engine]Syntax Error: {:<< ??? >>:RETURN_VALUE = call GetMinPrice30Days(::pvm, ::tuote, ::myymala)}
This is repeated with unidac 10.3 (delphi 12) and 9.x (delphi 10.3.1)
Database is actian ZEN v 15.2