-

   rss_sql_ru_access_programming

 - e-mail

 

 -

 LiveInternet.ru:
: 16.03.2006
:
:
: 4

:


txt

, 08 2015 . 11:40 +
, . ACCESS xml POST . txt ( ), , txt log. , , xml Access. , , . ANSI utf-8. 1 txt VBA. , xml , -, , , .
.



1 Private Sub check_etr_Click()
2 On Error GoTo Err_check_etr_Click

3 Set objXml = CreateObject("Msxml2.XMLHTTP")
4 Set objXmlDoc = CreateObject("MSXML2.DOMDocument")
5 Dim rs As Recordset
6 Dim doc As String, ccode As String, x As String, y As String, my_rc As String
7 Dim rc_int As Integer, rc_full As Double, z As Integer


8 Set rs = CurrentDb.OpenRecordset("check_entered_cards")

9 If rs.RecordCount > 0 Then
10 rs.MoveFirst
11 Do While Not rs.EOF
12 mycart = "" & rs("card_code") & "" & mycart
13 rs.MoveNext
14 Loop
15 End If

16 strXML = "" & _
17 "" & _
18 mycart & _
19 "
" & _


20 Open "D:\c_info_list_exp.txt" For Output As #1
21 Print #1, (strXML)
22 Close #1

23 objXml.Open "POST", "http://000.000.000.000:81/UCS/SOAP/SOAP.php?xml_data=" & strXML, False
24 objXml.send (strXML)


25 Open "D:\c_info_list.txt" For Output As #1
26 Print #1, strXML
27 Close #1

28 FileCopy "D:\c_info_list.txt", "D:\c_info_list" & ".xml"
29 ImportXML "D:\c_info_list.xml"

30 Exit_check_etr_Click:
31 Exit Sub

32 Err_check_etr_Click:
33 MsgBox Err.description
34 Resume Exit_check_etr_Click

35 End Sub

http://www.sql.ru/forum/1155649/izmenenie-kodirovki-txt-fayla


: [1] []
 

:
: 

: ( )

:

  URL