Knowledgebase: Sp_commands & Reports
[QODBC-Desktop] Troubleshooting: Error [QODBC] Field not allowed in insert/update - (#10046)
Posted by Rajendra Dewani (QODBC Support) on 26 December 2013 09:10 AM

Problem Description:

I am attempting to add InvoiceLine records to a sample company.  I exported 15 InvoiceLine records from QuickBooks via QODBC, then built a table with these records trimmed down to what I believe are the minimum required fields, then appended this table back to the QODBC InvoiceLine linked table.

I received the following error message: ODBC - insert on a linked table "InvoiceLine" failed.
[QODBC]Field not allowed in insert (#10046)

Solution:

There are few columns, values for which automatically generated by QuickBooks SDK and are not allowed during Insert/Update. Example ListID or TxnID

You can get more information about whether a column is allowed during Insert/Update or not, by typing below command in VB Demo:

sp_columns TableName

For Example: sp_columns InvoiceLine

The command will return the schema rules of selected table (In this example it is InvoiceLine), including information about whether a column is updatable or insertable.

When you try to insert the non-insertable field in your query, QODBC will show error "[QODBC]Field not allowed in insert ".

So when you get "Field not allowed in insert" error, please check your insert statement it may contain one or more non-insertable fields. Please remove non-insertable fields from the query and try to execute the SQL statement again.

When you try to update the non-updateable field in your query, QODBC will show error "[QODBC]Field not allowed in update ". So when you get "Field not allowed in update" error please check your update statement, it may contain one or more non-updateable fields. Please remove non-updateable fields from the query and try to execute the SQL statement again.

 

Tags: Table Field Types, Field Types, What does field type mean

 

(3 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).