-
$selectfetch in SQL Worker Lists, any way to edit query / pass bindvars?
Hi all,
There are any way to edit the generated query that will be executed by the worker in the $selectfetch command or to pass bindvars to the query?
In the documentation (https://www.omnis.net/developers/resources/onlinedocs/index.jsp?detail=Programming/07sqlprog.html#sql-worker-lists) I only see a parameter to append text after the SELECT clausule.
I ask because, it seems that the only way to see the executed query is in the $completed method, after the query is executed, but not seems possible to edit the query that will be executed and at the same time it seems that there isn’t any way to pass bindvars (witch are allowed by the worker, and i can see them in the $completed, but i can’t set them).
If that can help i am using Omnis Studio 11.1.111037255 (desktop).
Thanks
Sorry, there were no replies found.
Log in to reply.