Knowledgebase
[QODBC-Desktop] Troubleshooting - "Error Parsing complete XML return string" error when trying to update table PriceLevelPerItem in MS Access
Posted by Jack - QODBC Support on 02 March 2015 12:48 PM

Troubleshooting - "Error Parsing complete XML return string" error when trying to update table PriceLevelPerItem in MS Access

Problem Description:

I constructed an Access database file (32bit Access 2003) with tables linked to QuickBooks. I can pull information from the related tables to other tables in Access using update queries with no problems. When I try to run an update query to change a value in the QuickBooks linked table, I receive the below error. I need help figuring out the error and how to fix it.

My query is:

UPDATE PriceLevelPerItem INNER JOIN ItemPricing ON PriceLevelPerItem.FQPrimaryKey <> ItemPricing.FQPrimaryKey SET PriceLevelPerItem.PriceLevelPerItemCustomPrice = [ItemPricing].[PriceLevelPerItemCustomPrice];

 

http://support.flexquarters.com/esupport/newimages/PriceLevelPerItem/step1.png

Solutions:

You need to include PriceLevelPerItemItemRefListID in your update statement.

You need to include below the line in your update statement to resolve this issue.

SET PriceLevelPerItem.PriceLevelPerItemItemRefListID = PriceLevelPerItem.PriceLevelPerItemItemRefListID For Example:

UPDATE PriceLevelPerItem INNER JOIN ItemPricing ON PriceLevelPerItem.FQPrimaryKey <> ItemPricing.FQPrimaryKey SET PriceLevelPerItem.PriceLevelPerItemItemRefListID = PriceLevelPerItem.PriceLevelPerItemItemRefListID, PriceLevelPerItem.PriceLevelPerItemCustomPrice = [ItemPricing].[PriceLevelPerItemCustomPrice];

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).