把搜索到的结果复制给另一张表。dim Rst1 as adodb.recordsetset Rst1=SearchSourceValue 'SearchSourceValue是一个函数,代码在下面Dim Rst2 As New ADODB.Recordset
Dim StrConn2 As String
Dim SQLConn2 As String
StrConn2 = "Provider=MSDASQL.1;Driver=Microsoft Visual Foxpro Driver;SourceDB=c:\dbf\;SourceType=DBF"
Conn2.CursorLocation = adUseClient
Conn2.Open StrConn2
Rst2.Open "select * from temp.dbf", Conn2, adOpenStatic, adLockOptimistic
'运行下面一句话的时候出错,告诉我对象没有打开
rst1.movefirst
While Not Rst1.EOF
Rst2.AddNew
Dim h As Integer
For h = 0 To Rst1.Fields.Count - 1
Rst2.Fields(h) = Rst1.Fields(h)
Next h
Rst2.Update
Rst1.MoveNext
Wend
Private Function SearchSourceValue() As ADODB.Recordset Dim StrSQL As String
Dim Conn As New ADODB.Connection
Dim StrConn As String
Dim Rst As New ADODB.Recordset StrSQL = "select * from 1.dbf"
StrConn = "Provider=MSDASQL.1;Driver=Microsoft Visual Foxpro Driver;SourceDB=c:\dbf\;SourceType=DBF"
If Conn.State = 1 Then
Conn.Close
End If
If Rst.State = 1 Then
Rst.Close
End If
Conn1.Open StrConn
Rst1.Open StrSQL, Conn, adOpenStatic, adLockOptimistic
set SearchSourceValue=Rst
End Function
Dim StrConn2 As String
Dim SQLConn2 As String
StrConn2 = "Provider=MSDASQL.1;Driver=Microsoft Visual Foxpro Driver;SourceDB=c:\dbf\;SourceType=DBF"
Conn2.CursorLocation = adUseClient
Conn2.Open StrConn2
Rst2.Open "select * from temp.dbf", Conn2, adOpenStatic, adLockOptimistic
'运行下面一句话的时候出错,告诉我对象没有打开
rst1.movefirst
While Not Rst1.EOF
Rst2.AddNew
Dim h As Integer
For h = 0 To Rst1.Fields.Count - 1
Rst2.Fields(h) = Rst1.Fields(h)
Next h
Rst2.Update
Rst1.MoveNext
Wend
Private Function SearchSourceValue() As ADODB.Recordset Dim StrSQL As String
Dim Conn As New ADODB.Connection
Dim StrConn As String
Dim Rst As New ADODB.Recordset StrSQL = "select * from 1.dbf"
StrConn = "Provider=MSDASQL.1;Driver=Microsoft Visual Foxpro Driver;SourceDB=c:\dbf\;SourceType=DBF"
If Conn.State = 1 Then
Conn.Close
End If
If Rst.State = 1 Then
Rst.Close
End If
Conn1.Open StrConn
Rst1.Open StrSQL, Conn, adOpenStatic, adLockOptimistic
set SearchSourceValue=Rst
End Function
解决方案 »
- windows server 2008 安装 Crystal report 10 服务器不成功,缺少Ntlmssp服务
- 谁能说说易语言,究竟是真正的中文编译器还是中文解释器?
- 请问计算当月有几个星期日(在线等待)
- 无标题栏窗口的移动
- 如何调用vc写的以字符指针为参数的API?
- 帮一下忙,哪里有这个控件,谢谢~
- 急急急 我用access2000作的库,为什么我的vb程序不能使用它。
- 有谁知道在网上怎样查看mcse的成绩
- 那为大虾有接触式IC卡的读些例子,急,急,急不胜感谢!!!
- zilong:如何用VB6关闭Windows2000(各种版本).ExitWindowsEx只在WIN98下有用,2000不可行
- 请教---如果Client端不装Access,系统可以用Access数据库吗??
- 从新制作程序的问题
Dim Conn As New ADODB.Connection
Conn.Open "Provider=MSDASQL.1;Driver=Microsoft Visual Foxpro Driver;SourceDB=c:\dbf\;SourceType=DBF"Conn.Execute "select * into temp.dbf from 1.dbf"
Conn.Open "Provider=MSDASQL.1;Driver=Microsoft Visual Foxpro Driver;SourceDB=c:\dbf\;SourceType=DBF"Conn.Execute "insert into temp.dbf select * from 1.dbf"
Conn.Open "Provider=MSDASQL.1;Driver=Microsoft Visual Foxpro Driver;SourceDB=c:\dbf\;SourceType=DBF"Conn.Execute "insert into temp.dbf select * from 1.dbf"