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
|
|
ODBC Errors when Updating ClassRefListID |
Author |
Message |
|
Posted : 2006-04-21 02:12:22 |
Hi,
We started using Classes in Quickbooks 2006 and needed to update all unclassified records to a particular class that we will be using going forward to represent the origional location. QODBC has been vital in allowing this conversion, but I have run into problems with these eight queries. Each of the following throw the "ERROR [42S00] [QODBC] Not supported" exception when run...
UPDATE CheckExpenseLine SET ExpenseLineClassRefListID='10000-1144330695' WHERE ExpenseLineClassRefListID IS NULL
UPDATE CreditCardChargeExpenseLine SET ExpenseLineClassRefListID = '10000-1144330695' WHERE ExpenseLineClassRefListID IS NULL
UPDATE CreditCardCreditExpenseLine SET ExpenseLineClassRefListID = '10000-1144330695' WHERE ExpenseLineClassRefListID IS NULL
UPDATE JournalEntryCreditLine SET JournalCreditLineClassRefListID = '10000-1144330695' WHERE JournalCreditLineClassRefListID IS NULL
UPDATE JournalEntryDebitLine SET JournalDebitLineClassRefListID = '10000-1144330695' WHERE JournalDebitLineClassRefListID IS NULL
UPDATE Sales SET ClassRefListID = '10000-1144330695' WHERE ClassRefListID IS NULL
UPDATE DepositLine SET DepositLineClassRefListID = '10000-1144330695' WHERE DepositLineClassRefListID IS NULL
UPDATE VendorCreditExpenseLine SET ExpenseLineClassRefListID = '10000-1144330695' WHERE ExpenseLineClassRefListID IS NULL
Queries to all other tables doing the same thing all work. Running these failing queries through access yields a similar error message. Does anyone have any ideas as to what is wrong and how to correct it?
Thanks in advance,
Kenny |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-04-21 11:54:34 |
For each table in QODBC there are rules on what columns are QUERYABLE, UPDATEABLE, INSERTABLE and REQUIRED_ON_INSERT. These rules are found by using the sp_columns stored procedure. At a rough glance your exception list are non-UPDATEABLE tables.
For example for CheckExpenseLine, if I run the following in VB Demo:
sp_columns CheckExpenseLine
you will see that nothing is actually UPDATEABLE:
A number of tables in QODBC can only be used to insert new records and the Sales table is actually a read-only view.
See also: Updating BillExpenseLine.ExpenseLineClassRefListID, BillExpenseLine.ExpenseLineClassRefFullName
|
|
|
|
|