对象'execute'的方法'_connection'失败!
Dim outconn As New ADODB.Connection
Dim OUTSTR As String
outconn.ConnectionString = Login.loginstr(此处为引用其他窗体的变量)
outconn.Open
OUTSTR = "SELECT 产品编码,产品名称,SUM(CASE 性质 WHEN '出库' THEN 数量*(-1) ELSE 数量 END) AS 结存数量 INTO STOCKKUCUN FROM KUCUN GROUP BY 产品编码,产品名称 order by 产品编码,产品名称"
outconn.Execute OUTSTR
肯定是SQL语句中SUM(CASE 性质 WHEN '出库' THEN 数量*(-1) ELSE 数量 END)的问题~
改成SUM(数量)一次性通过~