makis_best Well-Known Member Licensed User Longtime User Apr 30, 2019 #1 Hi I have a B4XTable full of rows inserted from a list. How I can update only the value let say of the 5 row, 6 cell? I update the list and I refresh the B4XTable or other way?
Hi I have a B4XTable full of rows inserted from a list. How I can update only the value let say of the 5 row, 6 cell? I update the list and I refresh the B4XTable or other way?
mangojack Expert Licensed User Longtime User May 1, 2019 #2 The code to update a cell: B4X: B4XTable1.sql1.ExecNonQuery2($"UPDATE data SET ${column.SQLID} = ? WHERE rowid = ?"$, Array As String(myNewText, RowId)) Study and alter the example here to suite your needs .. https://www.b4x.com/android/forum/threads/b4x-b4xtable-editable-table-and-export-to-csv.102847/ Upvote 0
The code to update a cell: B4X: B4XTable1.sql1.ExecNonQuery2($"UPDATE data SET ${column.SQLID} = ? WHERE rowid = ?"$, Array As String(myNewText, RowId)) Study and alter the example here to suite your needs .. https://www.b4x.com/android/forum/threads/b4x-b4xtable-editable-table-and-export-to-csv.102847/