Android Question B4XTable - DataView

[LucaMs]

B4XTable: How to check if a DataView has been created (data is filtered)?

 

[Erel]

Not sure that I understand the question. It is your code that creates the data view (B4XTable.CreateDataView).

 

[LucaMs]

Not sure that I understand the question. It is your code that creates the data view (B4XTable.CreateDataView).

Yes, I set the DataView but at that point, if I want to execute a query on the DB internal to the B4XTable (sql1), I don't know whether the DataView (the view on the table) is active or not, so if in the query write: ... From 'TempView' or From 'data'.

I can use a boolean global variable to do the checking but, like all global variables, it is best to avoid them, for known reasons.

A read-only Boolean property based on the private variable SQLTableName would be enough: Return SQLTableName = "TempView".

 

[Erel]

For now you can use this hack:

Private Sub IsDataViewApplied As Boolean
    Dim query As String =  B4XTable1.BuildQuery(False)(0)
    Return query.Contains("FROM TempView")
End Sub

 

[LucaMs]

For now you can use this hack:

Private Sub IsDataViewApplied As Boolean
    Dim query As String =  B4XTable1.BuildQuery(False)(0)
    Return query.Contains("FROM TempView")
End Sub

Very helpful. Thanks, Erel