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 on Vendor Update |
Author |
Message |
KofK |
|
Group | : Members |
Posts | : 43 |
Joined | : 2006-04-04 |
|
Profile |
|
Posted : 2007-02-17 02:56:53 |
In the "Sample Rock Castle Construction" Company if I try to update the Salutation in the Vendor table I get a "Error parsing complete XML return string" error. Here is my SQL statement:
UPDATE Vendor SET Salutation = 'Mr.', CompanyName = 'TEST' WHERE AccountNumber = '85-93117'
If I take out the Salutation or only update the Salutation it works fine. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-02-17 10:13:40 |
When the QODBC Software Engineer added the new columns for QuickBooks 2007, he broke the re-ordering of all UPDATEs, which means ALL Updates must set the order of columns as they appear in the table. A sp_columns of the Vendor table shows CompanyName proceeds Salutation:
UPDATE Vendor SET CompanyName = 'TEST', Salutation = 'Mr.' WHERE AccountNumber = '85-93117'
should work. The re-ordering of updates is being fixed. |
|
|
|
|