• Omnis General Forum

  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, 10 months ago 1 Member · 0 Replies

  • General Coding
• 0 Replies

Log In to Reply