Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

stored Procedure use for Report

Biertrinker
Posts: 6
Joined: Wed Jun 29, 2016 8:53 am

stored Procedure use for Report

Unread post by Biertrinker »

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====
Post Reply