ESEC语法错误，帮忙看看

terry183 2008-09-19 04:30:24

str_QureySQL = "DECLARE @sql VARCHAR(8000)"
str_QureySQL = str_QureySQL & " SET @sql='SELECT barcode,ProductNo,Named,Standard,Unit'"
str_QureySQL = str_QureySQL & " SELECT @sql=@sql+',['+storage+']=MAX(CASE storage WHEN '''+storage+''' THEN StockAmt ELSE 0 END)'"
str_QureySQL = str_QureySQL & " + ',['+storage+']=MAX(CASE storage WHEN '''+storage+''' THEN StockCash ELSE 0 END)' "
str_QureySQL = str_QureySQL & " + ',['+storage+']=MAX(CASE storage WHEN '''+storage+''' THEN CostPrice ELSE 0 END)' "
str_QureySQL = str_QureySQL & " FROM V_FindProducts GROUP BY storage Having" & sql & " "
str_QureySQL = str_QureySQL & " EXEC(@sql+' FROM V_FindProducts GROUP BY barcode,ProductNo,Named,Standard,Unit Having" & sql & " ')"

SQL高手们帮看看，我在调试时，报错了，说我“ESEC语法错误”，该怎样改？

近期没什么分能派了....不胜感激~！

...全文

108 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

terry183 2008-09-20

打赏
举报

我再整理一下这个报错的SQL语句吧~~~~高手们请看下面：





queryCondition = " ProductNo like '" & TxtProductNo.Text.Trim & "%' AND"



sql = " ClassNo in (Select ClassNo from V_FindProducts where ParentNo='" & str_CNO(1).Trim("]") & "')  and " & queryCondition





str_QureySQL = "DECLARE @sql VARCHAR(8000)"

            str_QureySQL = str_QureySQL & " SET @sql='SELECT barcode,ProductNo,Named,Standard,Unit'"

            str_QureySQL = str_QureySQL & " SELECT @sql=@sql+',['+storage+']=MAX(CASE storage WHEN '''+storage+''' THEN StockAmt ELSE 0 END)'"

            str_QureySQL = str_QureySQL & " + ',['+storage+']=MAX(CASE storage WHEN '''+storage+''' THEN StockCash ELSE 0 END)' "

            str_QureySQL = str_QureySQL & " + ',['+storage+']=MAX(CASE storage WHEN '''+storage+''' THEN CostPrice ELSE 0 END)' "

            str_QureySQL = str_QureySQL & " FROM V_FindProducts GROUP BY storage Having" & sql & " "

            str_QureySQL = str_QureySQL & " EXEC(@sql+' FROM V_FindProducts GROUP BY barcode,ProductNo,Named,Standard,Unit Having" & sql & " ')"

编译时，系统报错：“EXEC语法错误”，我真的不懂如何修改了，请SQL高手们帮个忙~！！感激不尽啊~~~

terry183 2008-09-19