Return to VB Demo and Disconnect from QuickBooks but leave the SQL Statement intact. If you were using Microsoft® Access to retrieve this data, you might think the code is faulty but it’s not.Ģ.Uncheck the box next to: Use Optimizer. What happened? The deleted entry is still listed even if you disconnect and reconnect to QuickBooks. The QuickBooks report now shows only the original three entries:īut what happens in VB Demo? Return to VB Demo and press the Query Button again: The new record is retrieved and there are now four entries for truck #188 in both QuickBooks and VB Demo. Next, we return to VB Demo and click the Query button again. VB Demo returns the same three entries as the QuickBooks report: Select TxnID, VehicleRefFullName, TripStartDate, TripEndDate,OdometerStart, OdometerEnd from VehicleMileage where VehicleRefFullName like ‘188%’ Now let’s open VB Demo that comes with QODBC and type an SQL Statement to retrieve the entries from truck #188: The Reports shows three entries for truck #188: Now let’s look at the QuickBooks Mileage report. ![]() To solve the problem, let’s recreate the issue.įirst, we’ll open the QODBC Setup screen and:ģ.Select the Radio Button next to: The start of every Query.Ĥ.Click Apply and OK and close the window.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |