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
|
|
Error parsing complete XML return string - ClassRefListID |
Author |
Message |
|
Posted : 2007-01-02 16:00:53 |
Using QuickBooks 2004 and trying to update the class on an invoice line like this:
UPDATE InvoiceLine set ClassRefListID = '640000-1122747557' where txnid = '1024F4-1167511395'
I get the following error:
ODBC--update on a linked table 'InvoiceLine' failed.
[QODBC] Error parsing complete XML return string. (#10052)
HELP! |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-01-03 00:56:44 |
If you need to update an exisiting InvoiceLine record you can use a statement similar to the one below with the "InvoiceLineTxnLineID". The TxnID in the WHERE statement is used for speed but could be omitted.
UPDATE "InvoiceLine" SET ClassRefListID = '640000-1122747557' WHERE "TxnID" = '1024F4-1167511395' And "InvoiceLineTxnLineID" = '7133-1197736106'
You will need to locate the "InvoiceLineTxnLineID" by quering the invoice first:
Select "InvoiceLineTxnLineID", "CustomerRefListID", "ClassRefListID", "RefNumber", "InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineRate", "InvoiceLineAmount", "InvoiceLineSalesTaxCodeRefListID" from "InvoiceLine" WHERE "TxnID" = '1024F4-1167511395' |
|
|
|
|