Oracle数据库 执行语句出错 对象’RecordCount'的方法’_Recordset'失败
xbyue 2003-10-16 03:37:21 Dim Conn As New ADODB.Connection
Dim Rs As New ADODB.Recordset
Dim StrSql As String
......
StrSql="select int_id from objecs"
Set Rs = Conn.Execute(StrSql)
MsgBox Err.Number
MsgBox Rs.RecordCount
测试正常!Err.Number为0
StrSql="select int_id from fx_alarm"
Set Rs = Conn.Execute(StrSql)
MsgBox Err.Number
MsgBox Rs.RecordCount
Err.Number为0,但是运行出错
出错提示“ 对象’RecordCount'的方法’_Recordset'失败
这个语句直接到Oracle上运行正确
请问是什么原因阿