B4J Question DBUtils.ExecuteTableView - SELECT - WHERE

[petr4ppc]

Dear friends,

please. I am trying to have in tableview only some rows:

choosefromtable="Select [number], [name] FROM mytable where Number=" & "+123456"
DBUtils.ExecuteTableView(SQL2, choosefromtable, Null, 0, mytableview)

but it is not functioned..
Please, where I am doing mistake?
Best regards
p´4ppc

 

[Erel]

DBUtils.ExecuteTableView(SQL2, "Select number, name FROM mytable where Number = ?", Array As String(123456), 0, mytableview)

 

[petr4ppc]

Thank you very much Erel,
It is SOLVED,
Best regards,
p4ppc