Android Question sqlite BETWEEN

[Almora]

hi..
I want to get values in range of numbers but no results. where am i doing wrong?
thanks..

Dim cur As Cursor = Main.data.ExecQuery("SELECT * FROM day WHERE BETWEEN ID=10 AND ID=21 ")

android.database.sqlite.SQLiteException: near "BETWEEN": syntax error (code 1): , while compiling: SELECT * FROM day WHERE BETWEEN ID=10 AND ID=21

what I want here is to get values in the range of 10 and 21. Including 10 and 21.

 

[Almora]

after research i found the right code.

Dim cur As Cursor = Main.data.ExecQuery("SELECT * FROM day WHERE ID BETWEEN 10 And 21 ")

 

[teddybear]

after research i found the right code.

You can specify a condition using Comparision or Logical Operators such as >, <, =, LIKE, NOT, etc, Also use where id>=10 and id <=21

 

[aeric]

after research i found the right code.

Yes, this should work.

 

[Mahares]

after research i found the right code.

where id>=10 and id <=21

Yes, this should work.

The preferred and faster way is to use BETWEEN with parameters:

Dim cur As Resultset= Main.data.ExecQuery2("SELECT * FROM day WHERE ID BETWEEN ? AND ? ", Array as Int(10, 21))

(you can use cursor instead of resultset if that is what you like)