[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 Added to the TableProblem DescriptionWhen recently added Custom Fields to the Purchase Order. The fields show up in the PurchaseOrderLine table as CustomFieldPurchaseOrderLineTEST, CustomFieldPurchaseOrderLineGroupTEST and CustomFieldPurchaseOrderLineGroupLineTEST but returns 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. SolutionPlease try to turn off the optimizer and then run the same query again in VB Demo to see if could get the custom field records then. If so, try the query below to manually optimize the PurchaseOrder table as an option: sp_optimizefullsync PurchaseOrderLine Or reset the optimizer file via How to switch OFF or RESET the QODBC Optimizer See also: How to setup QODBC Optimizer and where are the Optimizer options | |
|