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

Home Forum Omnis General Forum SqlLite update not working

  • SqlLite update not working

    Posted by Coralie on June 6, 2019 at 4:33 pm

    Hi everyone,
    I’m working with JsRemote form under Omnis 8.1 and I’m having a really hard time with an update…
    I’m using an SqlLite database and my main form is made of a tab component. First tab is a smartlist, second tab is a row.
    Both are linked with the PK/FK, I can insert both in the database, and I can update the second tab (therefore the row).
    But no matter what I try, I cannot succeed to update the list. Since it’s a smartlist I’ve tried $dowork(), $doupdates(), then an SQL Statement, I even tried within a loop to pass my line’s list as rows to use the iRow.$update(iOldRow), but it still did not work. If anyone has any idea of what could possibly be wrong, I’m all ears and I’ll be forever grateful…
    Thanks in advance,

    Coralie replied 4 years, 9 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

Log in to reply.