I am attempting to update an existing purchase order line with the following sql syntax:
Update PurchaseOrderLine set VendorRefListID='260000-934380930', PurchaseOrderLineItemRefListID='60000-934380927',PurchaseOrderLineDesc='Garden walkway lights',PurchaseOrderLineQuantity=28,PurchaseOrderLineRate=14.75,PurchaseOrderLineCustomerRefListID='8C0000-1197736963' where TxnId='2B-934382526' and PurchaseOrderLineTxnLineID = '2D-934382526'
2006-10-16 14:49:30 QODBC Ver: 7.00.00.194 *********************************************************************************************************************
IsAService: False
SQL Statement: Update PurchaseOrderLine set VendorRefListID='260000-934380930', PurchaseOrderLineItemRefListID='60000-934380927',PurchaseOrderLineDesc='Garden walkway lights',PurchaseOrderLineQuantity=28,PurchaseOrderLineRate=14.75,PurchaseOrderLineCustomerRefListI
D='8C0000-1197736963' where TxnId='2B-934382526' and PurchaseOrderLineTxnLineID = '2D-934382526'
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 = "includeNone">
<PurchaseOrderModRq requestID = "1">
<PurchaseOrderMod>
<TxnID>2B-934382526</TxnID>
<EditSequence>1197755303</EditSequence>
<PurchaseOrderLineMod>
<TxnLineID>2D-934382526</TxnLineID>
<ItemRef>
<ListID>60000-934380927</ListID>
</ItemRef>
<Desc>Garden walkway lights</Desc>
<Quantity>28.00000</Quantity>
<Rate>14.75000</Rate>
<CustomerRef>
<ListID>8C0000-1197736963</ListID>
</CustomerRef>
</PurchaseOrderLineMod>
<PurchaseOrderLineMod>
<TxnLineID>2E-934382526</TxnLineID>
</PurchaseOrderLineMod>
<PurchaseOrderLineMod>
<TxnLineID>2F-934382526</TxnLineID>
</PurchaseOrderLineMod>
<VendorRef>
<ListID>260000-934380930</ListID>
</VendorRef>
</PurchaseOrderMod>
</PurchaseOrderModRq>
</QBXMLMsgsRq>
</QBXML>
If I remove the VendorRefListID field the query works fine.
| 
