I'm working on my first App that uses a SQLite database and all seems to be going quite well. I can read the database into my app, change data within records and make sure the changes are stored, all with no problem.
Now, as part of the major functionality of the program, I need to be able to filter my list of data and display only part of it. I have no problem with the display of the list, but I just don't know enough SQL to figure out how to return a set of results that contain the string (or strings) typed into the filter.
my basic select - to get all records looks like this:
and this works just fine. I need to look for a partial string within the Common column and return the results.
I have tried loads of stuff using what I can find around the net, but nothing actually gives me a new list.
Any suggestions much appreciated.
David
Now, as part of the major functionality of the program, I need to be able to filter my list of data and display only part of it. I have no problem with the display of the list, but I just don't know enough SQL to figure out how to return a set of results that contain the string (or strings) typed into the filter.
my basic select - to get all records looks like this:
B4X:
SELECT _id,Common,Scientific,Seen FROM t_birdsand this works just fine. I need to look for a partial string within the Common column and return the results.
B4X:
SELECT _id,Common,Scientific,Seen FROM t_birds WHERE Common **SOME STRING**I have tried loads of stuff using what I can find around the net, but nothing actually gives me a new list.
Any suggestions much appreciated.
David