Android Question Sort from SQL

[parijs]

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

 

[DonManfred]

I get no error but no sort

I dont believe.
Upload a small project which shows the problem. dont forget the database.

 

[fixit30]

If the field storing is a string type that holds numeric values then this could be the issue here.

 

[parijs]

Yes it is

storing
B00 CV
B05
B00 WW
B01 CV
B01 WW
B06
B09

 

[eps]

What were you expecting and what did you get...?