Android Question b4xtable add lines/rows

[fernando gibert]

Pls!

Is it possible to add rowlines to the bxtable ?

smthg as insert instead off sqli1 update ?

Thanks

 

[Mahares]

This line adds a record to the bottom of the B4XTable (not to the database table) if table has 4 columns:

B4XTable1.sql1.ExecNonQuery2($"INSERT INTO data VALUES(?,?,?,?)"$ , Array As Object(50000, "N1", "S1",1000))

 

[fernando gibert]

Thanks I'll try !!

 

[Erel]

Call B4XTable1.ClearDataView after you add or remove rows. This will update the counter.

 

[Alexis Martial]

Thanks Erel, helpful to be able to directly change internal B4XTable Data, this avoid having to reset it with the full list.

 

[fernando gibert]

Using dbutils the internal data are "updatable"-.

Pls !

difference between cleardataview & refresh ????

Thanks

 

[Erel]

ClearDataView should be called after you added or removed items from the internal database (or when you want to remove a previously created data view). It calls Refresh internally.

Refresh should be called when you want to force the table to redraw itself.

 

[fernando gibert]

Fine !!!!
Thanks alot