Maybe now I understand (at last). You simply want to know how to update and display data in a B4XTable - the data involved and where it comes from is not part of the question, and "instant synchronisation" is not an issue.
There are other similar questions in the forum so you are not the first person to have this problem but I cannot find a clear answer. The post
here seems to be as good as any. It includes this code snippet . . .
Sub SetValue (tbl As B4XTable, RowId As Long,value As String)
tbl.sql1.ExecNonQuery2($"UPDATE data SET ${column.SQLID} = ? WHERE rowid = ?"$, Array As String(value, RowId))
'updates the specific cell data
B4XTable1.Refresh
End Sub
I cannot help you more myself unless I write a test app which I do not have time to do. I still think that it would be easier to help you if you posted more code, including the code that changes the database.