Dim sr1 As String
Dim cslj As New adodb.Connection
sr1 = "EXEC master..xp_cmdshell 'bcp" & """ SELECT * FROM " & a & ".dbo.PM_StandTbl""" & " queryout " & temp & "StandTbl.txt -c -S" & """" & c & """" & " -U" & """flying""" & " -P" & """123""" & "'"
cslj.Execute sr1这是一个数据导出的语句,为什么在运行的时候没有报错,而却找不到结果。是不是sql语句没有取出数据呢?单步跟踪可以执行到!请各位高手帮忙看看,,谢谢!
Dim cslj As New adodb.Connection
sr1 = "EXEC master..xp_cmdshell 'bcp" & """ SELECT * FROM " & a & ".dbo.PM_StandTbl""" & " queryout " & temp & "StandTbl.txt -c -S" & """" & c & """" & " -U" & """flying""" & " -P" & """123""" & "'"
cslj.Execute sr1这是一个数据导出的语句,为什么在运行的时候没有报错,而却找不到结果。是不是sql语句没有取出数据呢?单步跟踪可以执行到!请各位高手帮忙看看,,谢谢!
Dim sql As String
Dim Cslj As New ADODB.Connection
'Dim tr As New ADODB.Recordset
Dim Xtsjljc As String
Dim tr As Recordset
Dim temp, n, t1, sr, sr1, a, c, d, e As StringPrivate Sub Form_Load()
Text1.Text = Dir1.Path
temp = Text1.Text
n = Form_user.Text2(2).Text
d = Form_user.Text2(1).Text
e = Form_user.Text2(0).Text Xtsjljc = "Provider=SQLOLEDB.1;" Xtsjljc = Xtsjljc + "Persist Security Info=False;" Xtsjljc = Xtsjljc + "Data Source=" + Trim(n) + ";" Xtsjljc = Xtsjljc + " Initial Catalog=" + "Master" + ";"
' Text1.Text = Xtsjljc
Cslj.Open Xtsjljc, e, d
End SubPrivate Sub Dir1_Change()
Text1.Text = Dir1.Path
temp = Text1.Text
End SubPrivate Sub Drive1_Change() t1 = Drive1.Drive
Dir1.Path = t1
End SubPrivate Sub CancelButton_Click()
Cslj.Close
Unload Me
End SubPrivate Sub OKButton_Click() If Cw_DataEnvi.DataConnect.State = 1 Then Cw_DataEnvi.DataConnect.Close
Cw_DataEnvi.DataConnect.Open Xtsjljc, e, d
sql = "select * from HDsystem_Databases where number='0001 '"
Set tr = Cw_DataEnvi.DataConnect.Execute(sql)
If Not tr.EOF Then
a = tr.Fields("DataBasesName")
c = tr.Fields("servername")
End If If Right(temp, 1) = "\" Then
temp = temp
Else
temp = temp & "\"
End If
sr1 = "EXEC master..xp_cmdshell 'bcp" & """ SELECT * FROM " & a & ".dbo.PM_StandTbl""" & " queryout " & temp & "StandTbl.txt -c -S" & """" & c & """" & " -U" & """flying""" & " -P" & """123""" & "'"
Set tr = Cw_DataEnvi.DataConnect.Execute(sr1)
tr.Close
sr1 = "EXEC master..xp_cmdshell 'bcp" & """ SELECT * FROM " & a & ".dbo.PM_StandTblName""" & " queryout " & temp & "StandTblName.txt -c -S" & """" & c & """" & " -U" & """flying""" & " -P" & """123""" & "'"
Set tr = Cw_DataEnvi.DataConnect.Execute(sr1)
tr.Close
sr1 = "EXEC master..xp_cmdshell 'bcp" & """ SELECT * FROM " & a & ".dbo.PM_Formula""" & " queryout " & temp & "Formula.txt -c -S" & """" & c & """" & " -U" & """flying""" & " -P" & """123""" & "'"
Set tr = Cw_DataEnvi.DataConnect.Execute(sr1)
tr.Close
MsgBox ("数据导出已完成!")
End Sub
Dim sql As String
Dim Cslj As New ADODB.Connection
Dim tr As New ADODB.Recordset
Dim Xtsjljc As String
'Dim tr as Recordset
Dim temp, n, t1, sr, sr1, a, c, d, e As StringPrivate Sub Form_Load()
Text1.Text = Dir1.Path
temp = Text1.Text
n = Form_user.Text2(2).Text
d = Form_user.Text2(1).Text
e = Form_user.Text2(0).Text Xtsjljc = "Provider=SQLOLEDB.1;" Xtsjljc = Xtsjljc + "Persist Security Info=False;" Xtsjljc = Xtsjljc + "Data Source=" + Trim(n) + ";" Xtsjljc = Xtsjljc + " Initial Catalog=" + "Master" + ";" Cslj.Open Xtsjljc, e, d
End SubPrivate Sub Dir1_Change()
Text1.Text = Dir1.Path
temp = Text1.Text
End SubPrivate Sub Drive1_Change() t1 = Drive1.Drive
Dir1.Path = t1
End SubPrivate Sub CancelButton_Click()
Cslj.Close
Unload Me
End SubPrivate Sub OKButton_Click() Dim tr As New ADODB.Recordset
sql = "select * from HDsystem_Databases where number='0001 '" tr.Open sql, Cslj
If Not tr.EOF Then
a = Trim(tr.Fields("DataBasesName"))
c = Trim(tr.Fields("servername"))
End If
If Right(temp, 1) = "\" Then
temp = temp
Else
temp = temp & "\"
End If
sr1 = "EXEC master..xp_cmdshell 'bcp" & """ SELECT * FROM " & a & ".dbo.PM_StandTbl""" & " queryout " & temp & "StandTbl.txt -c -S" & """" & c & """" & " -U" & """flying""" & " -P" & """123""" & "'"
Cslj.Execute sr1
sr1= "EXEC master..xp_cmdshell 'bcp" & """ SELECT * FROM " & a & ".dbo.PM_StandTblName""" & " queryout " & temp & "StandTblName.txt -c -S" & """" & c & """" & " -U" & """flying""" & " -P" & """123""" & "'"
cslj.Execute sr1
sr1= "EXEC master..xp_cmdshell 'bcp" & """ SELECT * FROM " & a & ".dbo.PM_Formula""" & " queryout " & temp & "Formula.txt -c -S" & """" & c & """" & " -U" & """flying""" & " -P" & """123""" & "'"
cslj.Execute sr1 tr.Close
MsgBox ("数据导出已完成!")
End Sub