Android Question Sort from SQL

parijs

Active Member
Licensed User
Longtime User
I have the code below

cur = SQL.ExecQuery("SELECT * FROM stor WHERE storing = '"&getSelection&"' AND ketelnr = '"& Main.keteltype &"'")

And if I want to sort it with

cur = SQL.ExecQuery("Select * FROM stor WHERE storing = '"&getSelection&"' AND ketelnr = '"& Main.keteltype &"' ORDER BY storing Asc")

I get no error but no sort
 

fixit30

Active Member
Licensed User
Longtime User
If the field storing is a string type that holds numeric values then this could be the issue here.
 
Upvote 0
Cookies are required to use this site. You must accept them to continue using the site. Learn more…