petr4ppc Well-Known Member Licensed User Longtime User Jun 22, 2014 #1 Dear friends, please. I am trying to have in tableview only some rows: B4X: 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
Dear friends, please. I am trying to have in tableview only some rows: B4X: 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 B4X founder Staff member Licensed User Longtime User Jun 22, 2014 #2 B4X: DBUtils.ExecuteTableView(SQL2, "Select number, name FROM mytable where Number = ?", Array As String(123456), 0, mytableview) Upvote 0
B4X: DBUtils.ExecuteTableView(SQL2, "Select number, name FROM mytable where Number = ?", Array As String(123456), 0, mytableview)
petr4ppc Well-Known Member Licensed User Longtime User Jun 22, 2014 #3 Thank you very much Erel, It is SOLVED, Best regards, p4ppc Upvote 0