Android Question Android 4.1.2 and 6.0 issues with SQlite

J

Juzer Hussain

Active Member
Licensed User
Longtime User
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
 
Sort by date Sort by votes
J

Juzer Hussain

Active Member
Licensed User
Longtime User
Juzer Hussain said:
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
Click to expand...

"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
 
Upvote 0
You must log in or register to reply here.

Similar Threads

J
  • Question
Android Question Problems with SQL, external storage and Android 14
Replies
12
Views
2K
Erel
D
  • Question
Android Question Problem with OpenMenu on Android v5.1
Replies
4
Views
917
davemorris
D
  • Question
Android Question My SQL Android issue with PHP file
Replies
2
Views
772
pin71
R
  • Question
Android Question Some problems with xChart
Replies
17
Views
2K
klaus
  • Question
Android Question Problem between HttpUtils2 and OkHttpUtils2 & android versions
Replies
2
Views
1K
techknight
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…