Android Question [solved] B4XTable Filter a Table Column

[Antonio Ferreira]

This is ok

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

this is not ok ... ?

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

or

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

[/CODE]


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

 

[Mahares]

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

It should be like this:

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