Android Question B4XTable - DataView

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

Erel said:

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

Click to expand...

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".

For now you can use this hack:

Erel said:

For now you can use this hack:

B4X:

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

Click to expand...

Very helpful. Thanks, Erel