stored Procedure use for Report

stored Procedure use for Report

Postby Biertrinker » Fri Jun 30, 2017 5:29 am

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====
Biertrinker
 
Posts: 6
Joined: Wed Jun 29, 2016 4:23 pm

Return to Report Writer