Android Question [solved] B4XTable Filter a Table Column

Antonio Ferreira · Aug 25, 2020

This is ok

B4X:

 Dim col2 As B4XTableColumn = B4XTable1.GetColumn("Sec")
 B4XTable2.CreateDataView($"${col2.SQLID.Trim} = 'ELT' "$)

this is not ok ... ?

B4X:

 Dim Msec As String
 Msec="ELT"
 B4XTable1.CreateDataView($"${col2.SQLID.Trim} = ${Msec} "$)

or

B4X:

 Dim Msec As String
 Msec="ELT"
 B4XTable1.CreateDataView($"${col2.SQLID.Trim} = '" & Msec & "' "$)

[/CODE]

How can filter a B4xtable column with a string (Msec) ?

Mahares · Aug 25, 2020

Antonio Ferreira said:
Dim Msec As String Msec="ELT" B4XTable1.CreateDataView($"${col2.SQLID.Trim} = ${Msec} "$)

It should be like this:

B4X:

Dim Msec As String
 Msec="ELT"
 B4XTable1.CreateDataView($"${col2.SQLID.Trim} = '${Msec}'  "$)

Privacy & Transparency