[QODBC-Desktop] Troubleshooting: Custom fields Value Are Blank after Added to the Table
Posted by Juliet (QODBC Support) on 30 August 2011 06:45 AM
Troubleshooting: Custom fields' Value Are Blank after being Added to the table
When recently added Custom Fields to the Purchase Order. The fields appear in the PurchaseOrderLine table as CustomFieldPurchaseOrderLineTEST, CustomFieldPurchaseOrderLineGroupTEST, and CustomFieldPurchaseOrderLineGroupLineTEST but return no data. We have the optimizer set ON with "The start of every new connection (with "Load Updated Date" first). I manually ran the Load Updated Data this morning and still have no data.
Please turn off the optimizer and rerun the same query in QODBC Support Wizard to see if you can get the custom field records. If so, try the question below to optimize the PurchaseOrder table as an option manually:
Or reset the optimizer file via How to switch OFF or RESET the QODBC Optimizer.