Android Question Android 4.1.2 and 6.0 issues with SQlite

[Juzer Hussain]

Hi Guys,

I am getting different results with same sql query in 4.1.2 and 6.0.The query is simple though but i suspect CAST function (I am casting TEXT to INT) and IN() functionality. Is this a known issue.
Pls advice.

Thanks
Juzer

 

[Juzer Hussain]

Hi Guys,

I am getting different results with same sql query in 4.1.2 and 6.0.The query is simple though but i suspect CAST function (I am casting TEXT to INT) and IN() functionality. Is this a known issue.
Pls advice.

Thanks
Juzer

"Cast" was the issue
AutoNumber >cast(" & sLastReadRecord & " As Int) fails in 4.1.2 works in 6.0
cast(AutoNumber as int)>cast(" & sLastReadRecord & " As Int) works in 4.1.2 works in 6.0
AutoNumberis TEXT field