... it works, but ...
Hi Erel,
Hi Erel,
Something like:
B4X:[LEFT][FONT=Courier New][SIZE=2][COLOR=#010101][COLOR=#010101][FONT=Courier New]Cmd.CommandText = "SELECT Name FROM Products"[/FONT][/COLOR][/COLOR][/SIZE][/FONT][/QUOTE] is working, but if I want to to filter the "Name" with that code .. Cmd.CommandText = "SELECT Name FROM Products WHERE Name = 'Banana' " it doesn't work. Do I have to write in a fist step the output from the "working solution" into a table and generate a new bList, or is there another way? Thanks in advance!