B4J Question TableView and SqlLite put issue.

[giga]

I am using TableView with SqlLite and able to see the database and fields. But when I try to modify a field and use wherefields.put nothing happens.
I don't get any error the field does not change. However if I go into the database through SQLlite expert and change it there it will show in the TableView.

Dim WhereFields AsMap
 WhereFields.Initialize
 WhereFields.Put("employ_id", "1234")
 DBUtils.UpdateRecord(sql1, "Office", "staff", 100, WhereFields)

Thanks everyone for their help.

 

[Erel]

The TableView is not directly connected to the SQL table. You will need to update the TableView data (or call DBUtils.ExecTable again).