Android Question update cell value b4xtable

[tamba sylvester]

is it possible to set value of a given cell in b4xtable

 

[Erel]

See this example: https://www.b4x.com/android/forum/t...table-table-and-export-to-csv.102847/#content

 

[tamba sylvester]

thanks,
this worked

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

note
column is b4xtable column
value is data to be passed

 

[LUISTORRES]

fired error

 

[tamba sylvester]

Make sure you define the column that you want to update.

'Define column
Private Amount As B4XTableColumn

'Initialize column
Amount=B4XTable1.AddColumn("Amount", B4XTable1.COLUMN_TYPE_text)

Then this how it will be

Sub SetValue (tbl As B4XTable, RowId As Long,value As String)
    tbl.sql1.ExecNonQuery2($"UPDATE data SET ${Amount.SQLID} = ? WHERE rowid = ?"$, Array As String(value, RowId))
    'updates the specific cell data
    B4XTable1.Refresh
End Sub