To solve the problem, let’s recreate the issue.
First, we’ll open the QODBC Setup screen and:
1.Click the Optimizer tab
2.Check the box next to Use Optimizer.
3.Select the Radio Button next to: The start of every Query.
4.Click Apply and OK and close the window.
Now let’s look at the QuickBooks Mileage report.
The Reports shows three entries for truck #188:
Now let’s open VB Demo that comes with QODBC and type an SQL Statement to retrieve the entries from truck #188:
Select TxnID, VehicleRefFullName, TripStartDate, TripEndDate,OdometerStart, OdometerEnd from VehicleMileage where VehicleRefFullName like ‘188%’
VB Demo returns the same three entries as the QuickBooks report:
What happened? The deleted entry is still listed even if you disconnect and reconnect to QuickBooks.
If you were using Microsoft® Access to retrieve this data, you might think the code is faulty but it’s not.
Open the QODBC Setup Screen and:
Return to VB Demo and Disconnect from QuickBooks but leave the SQL Statement intact.
Now the deleted entry is gone because you’re no longer using the Optimizer. You are not storing anything in a local store. You are pulling data directly from QuickBooks.
Now return to VB Demo, disconnect and reconnect to QuickBooks.
Click the Query Button again. The deleted entry is still listed.
Using the Optimizer speeds up retrieval but if you’re using a database to frequently update and delete data, leave this option unchecked to ensure the database is as current as possible.
You can try this for yourself using the QuickBooks sample file. Never experiment with your company file.
Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.