Search in more Colums

[Fox]

How can i search in more colums

for example:

Cursor = ST.ExecQuery("Select * FROM Database WHERE Searchword1 OR Searchword2 >'" & Searchbox.Text & "'")

is or the right word for search in more database colums?

or must i use an &

 

[Erel]

You can use OR to combine two WHERE clauses:
Select * FROM database WHERE col1 = 'abc' OR col1 = 'def'

BTW, I recommend you to use ExecQuery2 instead of ExecQuery. Or even better use DBUtils: http://www.b4x.com/forum/basic4andr...475-dbutils-android-databases-now-simple.html

 

[Fox]

You can use OR to combine two WHERE clauses:
Select * FROM database WHERE col1 = 'abc' OR col1 = 'def'

BTW, I recommend you to use ExecQuery2 instead of ExecQuery. Or even better use DBUtils: http://www.b4x.com/forum/basic4andr...475-dbutils-android-databases-now-simple.html

Thanks erel i have changed to ExecQuery2 and it works fantastic thank you very much for you quick help