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
|
|
Can't update UPDATE BillAddressAddr5 or ShipAddressAddr5 |
Author |
Message |
KofK |
|
Group | : Members |
Posts | : 43 |
Joined | : 2006-04-04 |
|
Profile |
|
Posted : 2007-10-24 05:10:56 |
When I try to run this SQL statement I get an error (3205): UPDATE Customer SET BillAddressAddr5 = 'Test' WHERE ListID = '80004A00-1193165136' |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-10-24 11:50:15 |
Yes, if you look at the QODBC Messages log in the QODBC Setup Screen Messages Tab it will most likely say something like this:
2007-10-24 11:07:38 QODBC Ver: 8.00.00.234 ********************************************************************************************************************* IsAService: False SQL Statement: UPDATE Customer SET BillAddressAddr5 = 'Address 5' WHERE ListID = '800000AB-1197771382' 3205 - There was an error when composing an address in "". QuickBooks error message: There is not enough address lines to compose the address. Please rearrange the individual fields, so that they can fit in the 5-lines block.
You will need to work out and pass the QuickBooks address rules in order to successfully UPDATE BillAddressAddr5 or ShipAddressAddr5.
|
|
|
|
KofK |
|
Group | : Members |
Posts | : 43 |
Joined | : 2006-04-04 |
|
Profile |
|
Posted : 2007-10-24 12:06:40 |
So I am able to INSERT but not UPDATE? Is that a bug or it's supposed to be like that? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-10-24 12:41:52 |
QODBC talks directly to QuickBooks and QuickBooks does all the verification of all inserts or updates. I suggest you create a customer record using the QuickBooks UI that actually has a value in BillAddressAddr5 first and then try updating it. |
|
|
|
|