Dim Name
Name = "Bluesky1"
Dim rs0 As New ADODB.Recordset
With rs0
.LockType = adLockOptimistic
.Open "select DISTINCT(Tariff_Customer) from Tariff", conn
End WithDim rs As New ADODB.RecordsetWith rs
.LockType = adLockOptimistic
.Open "select * from Tariff where Tariff_Customer =" & "'" & rs0.Fields("Tariff_Customer") & "'", conn
End With
提示错误:表Tariff已经打开。请问如何能同时访问一个表?
Name = "Bluesky1"
Dim rs0 As New ADODB.Recordset
With rs0
.LockType = adLockOptimistic
.Open "select DISTINCT(Tariff_Customer) from Tariff", conn
End WithDim rs As New ADODB.RecordsetWith rs
.LockType = adLockOptimistic
.Open "select * from Tariff where Tariff_Customer =" & "'" & rs0.Fields("Tariff_Customer") & "'", conn
End With
提示错误:表Tariff已经打开。请问如何能同时访问一个表?
也不行啊
Name = "Bluesky1"Dim rs0 As New ADODB.Recordset
rs0.Open "select DISTINCT(Tariff_Customer) from Tariff", conn,1,1Dim rs As New ADODB.Recordset
rs.Open "select * from Tariff where Tariff_Customer =" & "'" & rs0.Fields("Tariff_Customer") & "'", conn,1,1
Name = "Bluesky1"Dim rs0 As New ADODB.Recordset
rs0.Open "select DISTINCT(Tariff_Customer) from Tariff", conn,1,1'======================
While Not rs0.EOF
'======================
Dim rs As New ADODB.Recordset
rs.Open "select * from Tariff where Tariff_Customer =" & "'" & rs0.Fields("Tariff_Customer") & "'", conn,1,1'===================
rs0.movenext
wend
'=================
请问如何解决阿?谢谢!
Name = "Bluesky1"Dim rs0 As New ADODB.Recordset
rs0.Open "select DISTINCT(Tariff_Customer) from Tariff", conn,1,1'======================
While Not rs0.EOF
'======================
Dim rs As New ADODB.Recordset
rs.Open "select * from Tariff where Tariff_Customer =" & "'" & rs0.Fields("Tariff_Customer") & "'", conn,1,1'===================
rs0.movenext
wend
'=================
请问如何解决阿?谢谢!
Dim Name
Name = "Bluesky1"Dim rs0 As New ADODB.Recordset
rs0.Open "select DISTINCT(Tariff_Customer) from Tariff", conn,1,1'======================
While Not rs0.EOF
'======================
Dim rs As New ADODB.Recordset
rs.Open "select * from Tariff where Tariff_Customer =" & "'" & rs0.Fields("Tariff_Customer") & "'", conn,1,1'===================
rs.close
rs0.movenext
wend
'=================
Name = "Bluesky1"Dim rs0 As New ADODB.Recordset
Dim rs As New ADODB.Recordsetrs0.Open "select DISTINCT(Tariff_Customer) from Tariff", conn,1,1'======================
While Not rs0.EOF
'======================
rs.Open "select * from Tariff where Tariff_Customer =" & "'" & rs0.Fields("Tariff_Customer") & "'", conn,1,1'===================
rs.close
rs0.movenext
wend
'=================