P parijs Active Member Licensed User Longtime User Jun 1, 2017 #1 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
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 Expert Licensed User Longtime User Jun 1, 2017 #2 parijs said: I get no error but no sort Click to expand... I dont believe. Upload a small project which shows the problem. dont forget the database. Upvote 0
parijs said: I get no error but no sort Click to expand... I dont believe. Upload a small project which shows the problem. dont forget the database.
fixit30 Active Member Licensed User Longtime User Jun 1, 2017 #3 If the field storing is a string type that holds numeric values then this could be the issue here. Upvote 0
P parijs Active Member Licensed User Longtime User Jun 1, 2017 #4 Yes it is storing B00 CV B05 B00 WW B01 CV B01 WW B06 B09 Upvote 0
eps Expert Licensed User Longtime User Jun 1, 2017 #5 What were you expecting and what did you get...? Upvote 0