Forums

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.

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

Sorry, there were no replies found.

Log in to reply.