I need to update the description and amount fields on entries in the EstimateLine table. The SQL UPDATE command accomplishes this just fine for normal Estimate lineitems, but when the entry is part of a Group Item I get the following error:
"Error parsing complete XML return string."
I have tried several ways to identify the entry I want to update, but nothing works. Examples:
UPDATE EstimateLine SET EstimateLineDesc = 'New description' WHERE EstimateLineTxnLineID = '3D36B-1153180652'
UPDATE EstimateLine SET EstimateLineDesc = 'New description' WHERE TxnID = '3D35E-1153180652' AND EstimateLineTxnLineID = '3D36B-1153180652'
UPDATE EstimateLine SET EstimateLineDesc = 'New description' WHERE TxnID = '3D35E-1153180652' AND EstimateLineSeqNo = 2 AND EstimateLineGroupSeqNo = 10
I can edit this information manually through the QuickBooks user interface, so why can't I do it using QODBC? |