Arguments in SQLiteDatabase raw query function are bound as Strings and it causes problems for me.
Example query (binding 50):
SELECT ? < 68
SELECT min(?, 68)
Such results are because
50 is bound as String and query looks like
SELECT '50' < 68 ; which returns
Having complicated query created at runtime I have to use
How to bind data as Integer?
I found one solution:
SELECT CAST( ? AS INTEGER ) < 68 ;
but it looks ugly. Is there any other way? I can't find any adequate methods in Android API.