Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

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

Forum : error when updating an estimate line that is part of a group itemSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v6 Forum

 New Topic 
 
 Post Reply 
[1]  
 error when updating an estimate line that is part of a group item 
 Author   Message 
  tcoyotl 
  
 Group: Members 
 Posts: 2 
 Joined: 2006-07-19 
 Profile
 Posted : 2006-07-19 06:57:36

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?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-07-19 13:22:03
I've confirmed this is a bug using QODBC v6.00.00.176 and it has been reported to our Software Engineer on Ticket ID: BR00000009 for resolution. 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to