这个句子在SQL中可以运行，为什么在VB中不可以？？？
rsDeptS.Open "select dept_dsc,asset_name,area_num from Asset_use union all select dept_dsc,asset_name,area_num from asset_add" & _
"where datepart(yyyy,pur_date)>=" & strYear1 & " and datepart(yyyy,pur_date)<=" & strYear2 & _
"and datepart(mm,pur_date)>=" & strMon1 & " and datepart(mm,pur_date)<=" & strMon2 & _
"order by dept_dsc", gcnGDmis
这个句子在SQL中可以运行，为什么在VB中不可以？？？
问题点数：0、回复次数：1Top
1 楼hzf005（红蜘蛛）回复于 2003-09-04 18:26:18 得分 0
rsDeptS.Open "select dept_dsc,asset_name,area_num from Asset_use union all select dept_dsc,asset_name,area_num from asset_add " & _
" where datepart(yyyy,pur_date)>= " & strYear1 & " and datepart(yyyy,pur_date)<= " & strYear2 & _
" and datepart(mm,pur_date)>= " & strMon1 & " and datepart(mm,pur_date)<= " & strMon2 & _
" order by dept_dsc ", gcnGDmis
注意引号之间的空格，因为你要组成可执行的SQL字符串！Top
