Thanks for the quick fix Borislav. ALthough it loads now, the resulting cursor looks strange with many blank rows. The web service said that the returned XML would be a "File" object. Does that make any sense to you? It looks to me like there should be several tables but XMLAdapter.LoadXML() does not get any XMLTables.
Mike
>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)
>>
>
>>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
