Nov 5, 2014 Replies: 1 What am I doing wrong Code: oRst = SQL.ExecQuery2("SELECT * FROM Bustrip ORDER BY sort Asc WHERE bus = ?", Array As String (Main.find)) Click to expand...
What am I doing wrong Code: oRst = SQL.ExecQuery2("SELECT * FROM Bustrip ORDER BY sort Asc WHERE bus = ?", Array As String (Main.find))
I IdasI4A Active Member Licensed User Longtime User Nov 5, 2014 #2 WHERE comes before ORDER BY Code: oRst = SQL.ExecQuery2("SELECT * FROM Bustrip WHERE bus = ? ORDER BY sort", ArrayAsString (Main.find))
WHERE comes before ORDER BY Code: oRst = SQL.ExecQuery2("SELECT * FROM Bustrip WHERE bus = ? ORDER BY sort", ArrayAsString (Main.find))
