Android Question b4xtable add lines/rows

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:

B4X:

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

 

Upvote 0

F

fernando gibert

Member

Licensed User

Longtime User

• Apr 5, 2019

• #3

Thanks I'll try !!

 

Upvote 0

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

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

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

F

fernando gibert

Member

Licensed User

Longtime User

• Apr 8, 2019

• #8

Fine !!!!
Thanks alot

 

Upvote 0