[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
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.
There are a few columns values are 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 the below command in QODBC Test Tool:
For Example: sp_columns InvoiceLine
The command will return the schema rules of the 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 the error "[QODBC]Field not allowed in insert ".
So when you get the "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 the error "[QODBC]Field not allowed in update ". So when you get the "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