Forums

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

Feed Forum Omnis General Forum SQL Worker and redraw. a subform

  • SQL Worker and redraw. a subform

    Posted by Per-Arne Svensson on April 24, 2026 at 2:12 pm

    Hi all,

    This is for Omnis 10.22 and remote forms.

    I’m new to SQL worker. When stepping through the methods I can see that the lists are populated correctly but they are not drawn on the screen.
    According to the Omnis documentation a call to the server is needed but how do I do that?
    When I click on a tab and then click back the lists are shown so there is an issue with redraw.

    Regards,
    Per-Arne Svensson

    Per-Arne Svensson replied 2 weeks, 5 days ago 3 Members · 4 Replies
  • 4 Replies
  • Andreas Pfeiffer

    Administrator
    April 24, 2026 at 2:28 pm

    Hi Per-Arne,

    Since the worker do their job on the server side, the $completed method of the worker would need to send a push to the client for synchronising the data. See also: https://www.omnis.net/developers/resources/onlinedocs/WebDev/02jsremoteforms.html#push-connections

    Hope this makes sense.

    Best,

    Andreas

    • Brian Allen

      Member
      April 30, 2026 at 7:15 am

      Thanks, that actually helped point me in the right direction.

      I ran into something similar recently and the key for me was exactly what you mentioned to https://www.omnis.net/developers/resources/onlinedocs/WebDev/02jsremoteforms.html#push-connections. Nothing updates on the client unless you explicitly push it. In my case, adding a push from the worker’s
      $completed
      and then forcing a redraw on the client side did the trick.

      Per-Arne, you can try something like triggering a client method via push that calls
      $redraw()
      (or refreshes the subform/list) once the data is ready. Without that, the UI just sits there with the old state until something else (like switching tabs) forces a refresh, which is what you’re seeing.

      So yeah, it’s not that your list isn’t populated—it’s just never told the client to repaint.

  • Per-Arne Svensson

    Member
    April 27, 2026 at 1:45 pm

    Thank you Andreas. It works beautiful now. Very happy!

    All the best,

    Per-Arne

Log in to reply.