[QODBC-Desktop] Troubleshooting - Cannot create new table using QODBC / Cannot add a new field to QODBC table
Posted by Jack - QODBC Support on 10 November 2014 02:21 PM
Troubleshooting - Cannot create a new table using QODBC / Cannot add a new field to the QODBC table
I'm trying to create a new table with VB Demo or QODBC Test Tool.
Can you send me a sample query to do this?
QODBC is an ODBC driver. Please remember that QODBC is not a database but rather a translation tool. QODBC acts as a 'wrapper' around the Intuit SDK so customers can finally get at their QuickBooks data using standard database tools;
You cannot create a new table from VB Demo or QODBC Test Tool because QODBC is just reading and writing to QuickBooks Company file via QB SDK. QuickBooks SDK provides data in XML format, and QODBC converts it to a table format.
What you are trying to do is a new table in the QuickBooks Company file, which is not supported. Thus, you cannot create/drop/alter table(s) from VB Demo or QODBC Test Tool.
Keywords: adding in a column, adding in a table, how to add a new table, how to add a new column