晕了,大家来看看,关于用集合保存记录集中的数据!
sunhq 2005-11-06 09:43:26 部分程序如下:
Dim MyClasses As New Collection
Set cnnDB = New ADODB.Connection
cnnDB.Open strConn
Set rst1 = New ADODB.Recordset
Set rst1 = cnnDB.Execute("select * from user where ID = 1")
if Not rst1.EOF then
MyClasses.Add rst1("ID"), "ID"
MyClasses.Add rst1("Name"), "Name"
end if
rst1.Close
ID = MyClasses("ID")
Name = MyClasses("Name")
执行到ID = MyClasses("ID")时提示错误“对象不再有效”,我研究了半天,发现只要记录集关闭就会这样!这是怎么回事,怎么解决