Forums

Find answers, ask questions, and connect with our
community all around the world.

Home Forum Omnis General Forum $selectfetch in SQL Worker Lists, any way to edit query / pass bindvars?

  • $selectfetch in SQL Worker Lists, any way to edit query / pass bindvars?

    Posted by Matteo on May 23, 2025 at 6:11 pm

    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

    Matteo replied 2 months, 1 week ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

Log in to reply.