[Gambas-user] Trying to update table in SQLite

[rocko]

I'm trying to send data back to a table after retrieving it and doing
some math to it.
I tried doing a table update like>> table.Update
But that doesn't seem to work.

CODE:
FNew.rTable = FMain.$hConn.Create("inventory") 
  sResult = $hConn.Find("inventory", id = &1, ID)
           For Each sResult
             $date1 = sResult!endDate
             $date2 = Now
             Print $date2
             $daysLeft = sResult!daysLeft
             $daysLeft = DateDiff($date2, $date1, gb.Day)
             Print $daysLeft
             FNew.rTable.Update

I need to update the "daysLeft" field in the "inventory" table.