F fernando gibert Member Licensed User Longtime User Apr 5, 2019 #1 Pls! Is it possible to add rowlines to the bxtable ? smthg as insert instead off sqli1 update ? Thanks
Pls! Is it possible to add rowlines to the bxtable ? smthg as insert instead off sqli1 update ? Thanks
M Mahares Expert Licensed User Longtime User Apr 5, 2019 #2 This line adds a record to the bottom of the B4XTable (not to the database table) if table has 4 columns: Code: B4XTable1.sql1.ExecNonQuery2($"INSERT INTO data VALUES(?,?,?,?)"$ , Array As Object(50000, "N1", "S1",1000)) Upvote 0
This line adds a record to the bottom of the B4XTable (not to the database table) if table has 4 columns: Code: B4XTable1.sql1.ExecNonQuery2($"INSERT INTO data VALUES(?,?,?,?)"$ , Array As Object(50000, "N1", "S1",1000))
Erel B4X founder Staff member Licensed User Longtime User Apr 7, 2019 #4 Call B4XTable1.ClearDataView after you add or remove rows. This will update the counter. Upvote 0
A Alexis Martial Member Licensed User Apr 7, 2019 #5 Thanks Erel, helpful to be able to directly change internal B4XTable Data, this avoid having to reset it with the full list. Upvote 0
Thanks Erel, helpful to be able to directly change internal B4XTable Data, this avoid having to reset it with the full list.
F fernando gibert Member Licensed User Longtime User Apr 8, 2019 #6 Using dbutils the internal data are "updatable"-. Pls ! difference between cleardataview & refresh ???? Thanks Upvote 0
Using dbutils the internal data are "updatable"-. Pls ! difference between cleardataview & refresh ???? Thanks
Erel B4X founder Staff member Licensed User Longtime User Apr 8, 2019 #7 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. Upvote 0
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.
