Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't convert this XML to cursor
Message
 
To
14/10/2005 17:04:41
Mike Sue-Ping
Cambridge, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01059325
Message ID:
01059327
Views:
13
Mike,
I just copy and paste your XML text into a file. Made first line to begins from 0 (no spaces before
And
XMLTOCURSOR("Test.XML","cTest",512) && 512 means the string you passed is file name
>Hi,
>
>I'm trying to convert some XML into a VFP cursor(s). XMLAdapter's LoadXML fails with the following:
>
>
>XMLError: XML Parse Error: Invalid XML declaration.
>Line 1, Position 5   <?xml version="1.0" encoding="utf-8" ?>
>
>
>XMLTOCURSOR() also fails with a similar error. Any ideas what is wrong?
>
>
>
>  <?xml version="1.0" encoding="utf-8" ?>
>  <getFileResult xmlns="http://www.Somesite.com/SomeWebService">
>  <dataError>false</dataError>
>  <errorString />
>  <tblFilesID>749</tblFilesID>
>  <openDate>2005-10-13T12:18:23.6330000-07:00</openDate>
>  <closeDate>0001-01-01T00:00:00.0000000-08:00</closeDate>
>  <tblUsersID_Originator>23064</tblUsersID_Originator>
>  <tblTypesID_Status>69</tblTypesID_Status>
>  <tblTypesID_FileType>14</tblTypesID_FileType>
>  <salePrice>0</salePrice>
>  <lastAccessesDate>2005-10-14T09:59:23.9170000-07:00</lastAccessesDate>
>  <listingPrice>0</listingPrice>
>  <CancelDate>0001-01-01T00:00:00.0000000-08:00</CancelDate>
>  <ArchiveDate>0001-01-01T00:00:00.0000000-08:00</ArchiveDate>
>  <Terms>Some text goes here.</Terms>
>  <fileID_old>0</fileID_old>
>  <tblPrePaidPurchasesID>80</tblPrePaidPurchasesID>
>  <RegionType>163</RegionType>
>  <isTest>false</isTest>
>  <fileStatus>Open</fileStatus>
>  <fileType>Sale</fileType>
>  <fileOriginatorName>Somebody</fileOriginatorName>
>  <escrowInfo>
>  <dataError>false</dataError>
>  <errorString />
>  <tblFilesID>749</tblFilesID>
>  <EscrowNumber>ESC12345</EscrowNumber>
>  <EstimatedCloseDate>2005-11-12T00:00:00.0000000-08:00</EstimatedCloseDate>
>  <ContractAcceptanceDate>2005-10-13T00:00:00.0000000-07:00</ContractAcceptanceDate>
>  <EstimatedDaysUntilClose>30</EstimatedDaysUntilClose>
>  </escrowInfo>
>  <titleInfo>
>  <dataError>false</dataError>
>  <errorString />
>  <tblFilesID>749</tblFilesID>
>  </titleInfo>
>  <addressInfo>
>  <dataError>false</dataError>
>  <errorString />
>  <tblFilesID>749</tblFilesID>
>  <tblAddressesID>22631</tblAddressesID>
>  <streetNumber>450</streetNumber>
>  <streetDirection />
>  <streetName>Test</streetName>
>  <streetSuffix>St</streetSuffix>
>  <city>City</city>
>  <zip>92749</zip>
>  <tblTypesID_State>22</tblTypesID_State>
>  <unit>102</unit>
>  <county />
>  <addressLine1>777 Test St</addressLine1>
>  <cityStateZip>City, ST 11111</cityStateZip>
>  </addressInfo>
>  </getFileResult>
>
>
>
>Mike
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform