Android Question B4XTable1.sql1.ExecQuery

[sigster]

Hi

how can I refresh B4XTable1 to filter from query

B4XTable1.sql1.ExecQuery("select * from data where c2 = 'Open'")
B4XTable1.Refresh

 

[toby]

B4XTable1.ClearDataView

 

[Erel]

The ExecQuery line doesn't do anything (except of to leak some resources).

 

[Mahares]

B4XTable1.sql1.ExecQuery("select * from data where c2 = 'Open'")

Your code should be something like this:

B4XTable1.CreateDataView($"c2 = 'Open' "$)
B4XTable1.Refresh

Please note that c2 is the third in memory database table column

B4XTable1.ClearDataView

Hi Toby: I think you meant: B4XTable1.CreateDataView. The syntax wording is so similar that it it is easy to confuse between both of them.

 

[sigster]

Thanks will try CreateDataView