Questions and discussion about using ProcessMaker: user interface, running cases & functionality
I'm not able to execute SQL Server stored procedures using the executequery. All queries work fine insert/update etc.
This is the code I use:
Code: Select all
$proc = @@PROCESS;
$result = executeQuery("SELECT DBS_UID FROM DB_SOURCE WHERE PRO_UID='$proc' " .

if (!is_array($result) or count($result) == 0) 

$db = $result[1]['DBS_UID'];
executeQuery ("EXEC UPD_RDA '20200901164359363','123',''", $db);
Any idea how to solve?
Thanks in advance.
Schermata del 2020-09-02 13-39-22.png
Schermata del 2020-09-02 13-39-22.png (72.38 KiB) Viewed 5199 times

The function is made for local queries and the syntax is as follows

variant executeQuery(string SQLStatement, string DBConnectionUID='workflow')

but in your example it is : executeQuery ("EXEC UPD_RDA '20200901164359363','123',''", $db);

string SQLStatement: The SQL statement to be executed, must begin with SELECT, INSERT, UPDATE, DELETE, EXECUTE, EXEC, SHOW, DESCRIBE, EXPLAIN or BEGIN.

I share with you the documentation
Multiple Uploader in Grids

RubyGarage provides professional web development c[…]

Hello omarvillada Please make sure to have tis […]

Notice: Creole.php

Hello ptmi1047, Please make sure to have tis lin[…]

hi i am need link download processmaker 3.7 lower[…]