stored Procedure use for Report
Posted: Thu Jun 29, 2017 9:59 pm
is it posible to
call a stored procedure for the Report ?
i’ve a stored procedure (test1) with 2 IN Parameters
i’ve create a Criteria Form with to Fields (#von# and #bis#)
in in the SQL field i write
"CALL test1('#von#','#bis#')";
but when i run the Report it comes this error
——
===PDO MESSAGE===
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"CALL test1('2017-06-07','2017-06-12')"' at line 1
===SQL===========
CREATE TABLE ___nu1595556b1ee423___ "CALL test1('2017-06-07','2017-06-12')";
===BACK TRACE====
call a stored procedure for the Report ?
i’ve a stored procedure (test1) with 2 IN Parameters
i’ve create a Criteria Form with to Fields (#von# and #bis#)
in in the SQL field i write
"CALL test1('#von#','#bis#')";
but when i run the Report it comes this error
——
===PDO MESSAGE===
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"CALL test1('2017-06-07','2017-06-12')"' at line 1
===SQL===========
CREATE TABLE ___nu1595556b1ee423___ "CALL test1('2017-06-07','2017-06-12')";
===BACK TRACE====