Private Sub Command1_Click()
Dim sqltxt As String
sqltxt = "delete temppr"
Set conn = New ADODB.Connection
Set rst = New ADODB.Recordset
conn.ConnectionString = "DSN=ylgl;UID=sa;PWD=;"
conn.Open
conn.Execute sqltxt
If condstr = "" Then
sqltxt = "insert into temppr select * from product where 报告编号=1"
Else
sqltxt = "insert into temppr select * from product where 报告编号=1 " + condstr
End If
conn.Execute sqltxt
conn.Close
If First = True Then DataEnvironment1.Command1
First = flase
DataEnvironment1.rsCommand1.Requery
DataReport1.Show vbModal
End Sub
报错是报在"DataEnvironment1.rsCommand1.Requery"这句上
Dim sqltxt As String
sqltxt = "delete temppr"
Set conn = New ADODB.Connection
Set rst = New ADODB.Recordset
conn.ConnectionString = "DSN=ylgl;UID=sa;PWD=;"
conn.Open
conn.Execute sqltxt
If condstr = "" Then
sqltxt = "insert into temppr select * from product where 报告编号=1"
Else
sqltxt = "insert into temppr select * from product where 报告编号=1 " + condstr
End If
conn.Execute sqltxt
conn.Close
If First = True Then DataEnvironment1.Command1
First = flase
DataEnvironment1.rsCommand1.Requery
DataReport1.Show vbModal
End Sub
报错是报在"DataEnvironment1.rsCommand1.Requery"这句上
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货