Questions and discussion about using ProcessMaker: user interface, running cases & functionality

Moderator: amosbatto

#783597
Hi All,

Trying to integrate ProcessMaker into SQL Server is exceedingly frustrating. I finally have the ability to populate grids from SQL tables and write them back again but when I try to use views instead everything stops working.

@@test_grid_rows = 1234;
$result =executeQuery("select shoot_date from IMPORT_PROD_DETAILS_T","41500854455788435d04564021257676");
@=test_grid = $result;
@@test_grid_rows = count($result);

If IMPORT_PROD_DETAILS_T is a table, the trigger works fine. If it's a view, it never even returns from the call to executeQuery.
I can trace SQL Server and the query comes across fine and the data gets returned.

Any ideas of why this happens?
How can I get any debugging info on what's happening with executeQuery?

Thanks,

Santi

hi His main problem is that he wants to make a pr[…]

Yes, there is a limit to executeQuery() function. […]

I found the solution, I must use case_Open like […]

Hi dan123dan, Thank you for the reply and providi[…]