执行存储过程能返回给记录集(recordset)吗,为什么他老说我对象关闭??高手们帮我看一下,急坏了啊???
Dim RS As ADODB.Recordset
Set RS = New ADODB.Recordset
Set record = Conn.Execute("exec sp_PSXFRR00 '" & Trim(lblfstrcode.Caption) & "','" & strRegister & "', '" & CDate(lblfxfrdate.Caption) & "','" & Trim(txtfxfrno.Text) & "','10010'")
Set rpt_XfrR00.DataSource = RS
‘或者下面执行================
Set rpt_XfrR00.DataSource = Conn.Execute("exec sp_PSXFRR00 '" & Trim(lblfstrcode.Caption) & "','" & strRegister & "', '" & CDate(lblfxfrdate.Caption) & "','" & Trim(txtfxfrno.Text) & "','10010'")
’=============================能这样吗?
rpt_XfrR00.Refresh
rpt_XfrR00.Show