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====
Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.