Apps "Search by" after import an Excel file

[Deleted User]

Take out the angle brackets from your query

db.execSQL("SELECT Company FROM " + tableName + " WHERE Company like " + etSearch.getText() + "%");

 

[GodLovesYou]

Take out the angle brackets from your query

db.execSQL("SELECT Company FROM " + tableName + " WHERE Company like " + etSearch.getText() + "%");

When I click on EditText and type "S" from Samsung for example the application stops and the error is:

FATAL EXCEPTION: main
                                                                          android.database.sqlite.SQLiteException: near "%": syntax error (code 1): , while compiling: SELECT Company FROM proinfo WHERE Company like S%

 

[Deleted User]

You need to surround the search value with single quotes. And I recommend that you read a tutorial on Sqlite.

SELECT Company FROM proinfo WHERE Company like 'S%'

 

[Deleted User]

Here's the syntax reference guide

https://www.sqlite.org/lang_select.html

 

[GodLovesYou]

Here's the syntax reference guide

https://www.sqlite.org/lang_select.html

I will try to do something and read more about this content. Thank you for your help!