标题: 用VB连接了TD服务器后如何执行SQL语句进行查询?调试时总是报:实时错误424 缺少对象 [打印本页] 作者: wyjzjwyj 时间: 2007-10-4 17:48 标题: 用VB连接了TD服务器后如何执行SQL语句进行查询?调试时总是报:实时错误424 缺少对象 以下是一个简单的小程序
Private Sub Command1_Click()
Dim com As TDAPIOLELib.Command
Dim RecSet As Recordset
Set com = tdc.Command //tdc在登录窗体中已经定义为 Dim tdc As New TDAPIOLELib.TDConnection,调试时该行变黄,报 错:实时错误424 缺少对象
com.CommandText = "select * from bug"
Set RecSet = com.Execute
For i = 1 To RecSet.RecordCount
List1.AddItem (RecSet.FieldValue(i))
RecSet.Next
Next
End Sub