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
|
|
Error parsing complete XML return string (8) |
Author |
Message |
Suvi |
|
Group | : Members |
Posts | : 4 |
Joined | : 2008-04-02 |
|
Profile |
|
Posted : 2009-01-20 15:54:06 |
Hello, I am getting 'Error parsing complete XML return string (8)' error when I execute this command: INSERT INTO Invoice (CustomerRefListID, ARAccountRefListID,TxnDate,RefNumber, BillAddressAddr1, BillAddressAddr2, BillAddressAddr3,BillAddressCity, BillAddressState, BillAddressPostalCode,BillAddressCountry,ShipAddressAddr1, ShipAddressAddr2, ShipAdd ressAddr3,ShipAddressCity, ShipAddressState, ShipAddressPostalCode,PONumber,ShipMethodRefListID,IsToBePrinted) VALUES ('80000002-1232376820','80000020-1232376585',{d'2008-02-25'},'500003','William Vick','7411 Tall Cedar','','San Antonio','TX','78249' ,'','William Vick','7411 Tall Cedar',' ','San Antonio','TX','78249','PON001831','80000006-1232376709',0) Can you help me?
Thanks and regards, Suvi Joseph |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-20 21:05:06 |
|
|
|
Suvi |
|
Group | : Members |
Posts | : 4 |
Joined | : 2008-04-02 |
|
Profile |
|
Posted : 2009-01-20 21:44:44 |
Hello Tom, Thanks for the reply. I am inserting invoiceline prior to invoice. I just posted the last command where I get the error. Now I give here the complete command. INSERT INTO InvoiceLine (InvoiceLineItemRefListID, InvoiceLineQuantity, InvoiceLineAmount, InvoiceLineDesc, FQSaveToCache) VALUES ('8000000A-1232376810', 1.00, 780.00, ' ', 1)
INSERT INTO InvoiceLine (InvoiceLineItemRefListID, InvoiceLineQuantity, InvoiceLineRate, InvoiceLineAmount, FQSaveToCache) VALUES ('80000005-1232376805', 1.00, 12.00, 12.00, 1)
INSERT INTO Invoice (CustomerRefListID, ARAccountRefListID,TxnDate,RefNumber, BillAddressAddr1, BillAddressAddr2, BillAddressAddr3,BillAddressCity, BillAddressState, BillAddressPostalCode,BillAddressCountry,ShipAddressAddr1, ShipAddressAddr2, ShipAdd ressAddr3,ShipAddressCity, ShipAddressState, ShipAddressPostalCode,PONumber,ShipMethodRefListID,IsToBePrinted) VALUES ('80000002-1232376820','80000020-1232376585',{d'2009-01-05'},'500055','William Vick','7411 Tall Cedar','','San Antonio','TX','78249' ,'','William Vick','7411 Tall Cedar',' ','San Antonio','TX','78249','PON001957','80000006-1232376709',0)
With regards, Suvi Joseph |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-21 08:30:41 |
Your second insert uses InvoiceLineRate. Please keep the InvoiceLine inserts as the same pattern. |
|
|
|
Suvi |
|
Group | : Members |
Posts | : 4 |
Joined | : 2008-04-02 |
|
Profile |
|
Posted : 2009-01-21 17:20:49 |
Hello Tom, I made the InvoiceLine inserts as same pattern. I am still having problem. The strange thing is that it works in other computer where QODBC driver 6 is installed even if we give different pattern in InvoiceLine inserts. The problem is in QODBC driver 8 installed computer. I post here the error message I get in error log:
2009-01-21 01:12:55 QODBC Ver: 6.00.00.138 ********************************************************************************************************************* IsAService: False SQL Statement: INSERT INTO Invoice (CustomerRefListID, ARAccountRefListID,TxnDate,RefNumber, BillAddressAddr1, BillAddressAddr2, BillAddressAddr3,BillAddressCity, BillAddressState, BillAddressPostalCode,BillAddressCountry,ShipAddressAddr1, ShipAddressAddr2, ShipAdd ressAddr3,ShipAddressCity, ShipAddressState, ShipAddressPostalCode,PONumber,ShipMethodRefListID,IsToBePrinted) VALUES ('80000002-1232517554','80000020-1232517423',{d'2008-02-25'},'500003','William Vick','7411 Tall Cedar','','San Antonio','TX','78249' ,'','William Vick','7411 Tall Cedar',' ','San Antonio','TX','78249','PON001831','80000006-1232517492',0) 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"> <InvoiceAddRq requestID = "1"> <InvoiceAdd defMacro = "TxnID:69E3A22F-CFBF-42F4-A857-81FFF9759801"> <CustomerRef> <ListID>80000002-1232517554</ListID> </CustomerRef> <ARAccountRef> <ListID>80000020-1232517423</ListID> </ARAccountRef> <TxnDate>2008-02-25</TxnDate> <RefNumber>500003</RefNumber> <BillAddress> <Addr1>William Vick</Addr1> <Addr2>7411 Tall Cedar</Addr2> <Addr3> </Addr3> <City>San Antonio</City> <State>TX</State> <PostalCode>78249</PostalCode> <Country> </Country> </BillAddress> <ShipAddress> <Addr1>William Vick</Addr1> <Addr2>7411 Tall Cedar</Addr2> <Addr3> </Addr3> <City>San Antonio</City> <State>TX</State> <PostalCode>78249</PostalCode> </ShipAddress> <PONumber>PON001831</PONumber> <ShipMethodRef> <ListID>80000006-1232517492</ListID> </ShipMethodRef> <IsToBePrinted>0</IsToBePrinted> <InvoiceLineAdd> <Amount>420.00</Amount> <ItemRef> <ListID>8000000A-1232517546</ListID> </ItemRef> <Desc> </Desc> <Quantity>1.00000</Quantity> </InvoiceLineAdd> <InvoiceLineAdd> <Amount>12.00</Amount> <ItemRef> <ListID>80000005-1232517541</ListID> </ItemRef> <Desc> </Desc> <Quantity>1.00000</Quantity> </InvoiceLineAdd> </InvoiceAdd> </InvoiceAddRq> </QBXMLMsgsRq> </QBXML> |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-22 08:26:55 |
|
|
|
|