[QODBC-Desktop] Troubleshooting - VehicleMileage table showing deleted records
Posted by Jack - QODBC Support on 05 April 2018 12:06 PM
Troubleshooting - VehicleMileage table showing deleted records
I am using QODBC for working with QuickBooks. I am able to delete the VehicleMileage record. But After that when I query VehicleMileage table it still showing deleted record.
The UNOPTIMIZED query working fine.
This issue is related to QuickBooks SDK. QuickBooks SDK is not returning deleted records in TxnDeleted & due to this QODBC cannot remove the deleted records from the Optimizer.
We have already reported QuickBooks SDK issue to Intuit.
Till the time Intuit fixes the issue we have applied workaround in QODBC V126.96.36.1996 that VehicleMileage table will directly fetch data from QuickBooks & does not use the Optimizer.
So if you are using QODBC V325 or earlier QODBC version, then you need to use "UNOPTIMIZED" keyword in your query for fetching correct records.
Select * from VehicleMileage UNOPTIMIZED