Updating data in a linked table is not supported
FYI, linked table is always in sync with Quick Books Data, so you cannot add or delete any columns in this table.
But you can directly modify the data in linked table, QODBC will automatically update the modification to Quick Books.
Since the values from picomp2 are returned as variants, they cannot be updated directly through SQL.
Either use pass-through queries or work with PI SQL views that cast the variant column into a data type that fits your data.
The table visualization and the Details-on-Demand (D-o-D) cannot display more than 10000 rows from an in-db data source.
The table and the D-o-D do not support data from cubes. Not all of the standard Spotfire aggregation methods and expressions are available on all external systems.
Import the source data into a new table in the current database: this option will directly extract tables into Access Data Base, you can view and edit these tables, but all modification will not be uploaded unless you build another query to do so.
Link to the data source by creating a linked table: this option will create a table just like the first option, but will keep its link to Quick Books, which means all your operation to this table will be uploaded to Quick Books, and the data in table is also in full sync with Quick Books.
Use the following procedure to view links or to refresh them when the structures of the linked tables have changed.
The foreign key constraint is satisfied if for each row in the child table either one or more of the child key columns are NULL, or there exists a row in the parent table for which each parent key column contains a value equal to the value in its associated child key column.
In the above paragraph, the term "equal" means equal when values are compared using the rules specified here.
(Note, however, that future releases of SQLite might change so that foreign key constraints enabled by default.
Careful developers will not make any assumptions about whether or not foreign keys are enabled by default but will instead enable or disable them as necessary.) The application can also use a PRAGMA foreign_keys statement to determine if foreign keys are currently enabled.