sql - Vb6 缺少运算符

Question

在我的学校项目中工作，当我将 ORDER BY 方面添加到我的 sql 时，尽管其余代码运行良好，但遇到了这个缺少运算符的错误。

Set rs_fav = db_kwickfix.OpenRecordset("
    SELECT Recipe.Rec_Name 
    FROM Recipe,Favourites 
    WHERE (Recipe.RecipeID = Favourites.RecipeID) 
        AND (Favourites.UserID = " & frm_login.user_id & ") 
    ORDER BY Recipe.Rec_Name DESCENDING
    ")

Answer 1

尝试DESC而不是DESCENDING，检查ORDER BY Clause (Transact-SQL)这是:

ORDER BY order_by_expression
[ COLLATE collation_name ]
[ ASC | DESC ]
[ ,...n ]
[ <offset_fetch> ]

因此:

Set rs_fav = db_kwickfix.OpenRecordset("
    SELECT Recipe.Rec_Name 
    FROM Recipe,Favourites 
    WHERE (Recipe.RecipeID = Favourites.RecipeID) 
        AND (Favourites.UserID = " & frm_login.user_id & ") 
    ORDER BY Recipe.Rec_Name DESC
    ")