Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
QODBC Error : Error parsing complete XML return string" on adding Vendors (Suppliers)? |
Author |
Message |
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-03-07 11:16:00 |
I'm trying to submit an Insert into the Vendor table to add a supplier, but I receive the following error:
"QODBC Error : Error parsing complete XML return string".
Here's the entry from the QODBCLog.txt 2006-03-06 13:16:58 QODBC Ver: 6.00.00.147 ********************************************************************************************************************* IsAService: False SQL Statement: INSERT INTO Vendor(IsActive, CompanyName, VendorAddressAddr1, VendorAddressAddr2, VendorAddressAddr3, VendorAddressCity, VendorAddressState, VendorAddressPostalCode, VendorAddressCountry, Phone, Fax, Email, AccountNumber, Notes) VALUES (1,'A-1 Sanitation Service', 'P.O. Box 9001706','','', 'Louisville','KY','40290-1706','','(910) 791-4048','','','176854','') Error parsing complete XML return string (8) Input XML: <?xml version="1.0" encoding="ISO-8859-1"?> <?qbxml version="5.0"?> <QBXML> <QBXMLMsgsRq onError = "continueOnError" responseData = "includeAll"> <VendorAddRq requestID = "1"> <VendorAdd> <IsActive>1</IsActive> <CompanyName>A-1 Sanitation Service</CompanyName> <VendorAddress> <Addr1>P.O. Box 9001706</Addr1> <Addr2> </Addr2> <Addr3> </Addr3> <City>Louisville</City> <State>KY</State> <PostalCode>40290-1706</PostalCode> <Country> </Country> </VendorAddress> <Phone>(910) 791-4048</Phone> <Fax> </Fax> <Email> </Email> <AccountNumber>176854</AccountNumber> <Notes> </Notes> </VendorAdd> </VendorAddRq> </QBXMLMsgsRq> </QBXML>
Any ideas?
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-03-07 11:20:21 |
The solution is to always insert the Vendor.Name column (as it's actually required on insert) like this:
INSERT INTO Vendor (IsActive, Name, CompanyName, VendorAddressAddr1, VendorAddressAddr2, VendorAddressAddr3, VendorAddressCity, VendorAddressState, VendorAddressPostalCode, VendorAddressCountry, Phone, Fax, Email, AccountNumber, Notes) VALUES (1,'A-1 Sanitation Service','A-1 Sanitation Service','P.O. Box 9001706','','','Louisville','KY','40290-1706','','(910) 791-4048','','','176854','')
|
|
|
|
|