dim cn as new adodb.connection cn.connection="..." cn.open cn.execute "exec exp('" & a & "','" & b & "')"
应该是:dim cn as new adodb.connection cn.connectionstring="..." cn.open cn.execute "exec exp '" & a & "','" & b & "'"
Dim cmd As New ADODB.Command Dim rsJJ As New ADODB.Recordset cmd.ActiveConnection = Cnn cmd.CommandType = adCmdStoredProc cmd.CommandText = "Rpt_grndjjtj" cmd.CommandTimeout = 0 cmd.Parameters.Refresh cmd.Parameters(1) = 参数1 cmd.Parameters(2) = 参数2 Set rsJJ = cmd.Execute() '返回记录集
Dim cmd As New ADODB.Command Dim rsJJ As New ADODB.Recordset cmd.ActiveConnection = Cnn cmd.CommandType = adCmdStoredProc cmd.CommandText = "存储过程" cmd.CommandTimeout = 0 cmd.Parameters.Refresh cmd.Parameters("参数名1") = 参数1 cmd.Parameters("参数名2") = 参数2 if rsjj.state=1 then rsjj.close end if Set rsJJ = cmd.Execute() '返回记录集// 这样的写法比较规范
cn.connection="..."
cn.open
cn.execute "exec exp('" & a & "','" & b & "')"
cn.connectionstring="..."
cn.open
cn.execute "exec exp '" & a & "','" & b & "'"
Dim rsJJ As New ADODB.Recordset
cmd.ActiveConnection = Cnn
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "Rpt_grndjjtj"
cmd.CommandTimeout = 0
cmd.Parameters.Refresh
cmd.Parameters(1) = 参数1
cmd.Parameters(2) = 参数2
Set rsJJ = cmd.Execute() '返回记录集
Dim rsJJ As New ADODB.Recordset
cmd.ActiveConnection = Cnn
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "存储过程"
cmd.CommandTimeout = 0
cmd.Parameters.Refresh
cmd.Parameters("参数名1") = 参数1
cmd.Parameters("参数名2") = 参数2
if rsjj.state=1 then
rsjj.close
end if
Set rsJJ = cmd.Execute() '返回记录集//
这样的写法比较规范
想把取得的值赋给变量只要
rsJJ.fields(0).value
就可以了。