Under the following condition the latest version of qodbc (7.0.) does not Delete line items from the PurchaseOrderLine table.
Create a purchase order with two regular items and then add a group item to the purchase order. Attempt to delete the regular items on the po with the following sql syntax:
Delete from PurchaseOrderLine where TxnID='F34-1071526924' and PurchaseOrderLineTxnLineID='2585-1071526924'
Results in the following error Message:
The Delete failed --[QODBC] Error parsing complete XML return string.
2006-10-12 16:11:38 QODBC Ver: 7.00.00.194 ********************************************************************************************************************* IsAService: True SQL Statement: Delete from PurchaseOrderLine where TxnID='F34-1071526924' and PurchaseOrderLineTxnLineID='2585-1071526924' 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>F34-1071526924</TxnID> <EditSequence>1197760261</EditSequence> <PurchaseOrderLineMod> <TxnLineID>F36-1071526924</TxnLineID> </PurchaseOrderLineMod> <PurchaseOrderGroupLineMod> <TxnLineID>2586-1071526924</TxnLineID> </PurchaseOrderGroupLineMod> <PurchaseOrderLineGroupRet> <PurchaseOrderLineRet> <TxnLineID>2587-1071526924</TxnLineID> </PurchaseOrderLineRet> <PurchaseOrderLineRet> <TxnLineID>2588-1071526924</TxnLineID> </PurchaseOrderLineRet> <PurchaseOrderLineRet> <TxnLineID>2589-1071526924</TxnLineID> </PurchaseOrderLineRet> <PurchaseOrderLineRet> <TxnLineID>258A-1071526924</TxnLineID> </PurchaseOrderLineRet> </PurchaseOrderLineGroupRet> </PurchaseOrderMod> </PurchaseOrderModRq> </QBXMLMsgsRq> </QBXML>
The same query works fine if no group items are present in the purchase order. |