Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Deleted Items still showing |
Author |
Message |
|
Posted : 2007-11-20 06:02:35 |
I have several Purchase Orders and Sales Orders that have been deleted from QuickBooks, but still show up through QODBC. I am running the VB Demo program to query the tables. I am using the unopimized option, have tried with the optimizer on or off, and have completely reloaded all tables. Some of these records are more than a year old, although I don't know for sure when they were actually deleted. Anything else I can try? I am currently running version 7.0.0.207. If there is a newer version of 7 that would help can you tell me how to download it? Only download option I get is for version 8. We are still running QuickBooks Enterprise version 6 so I don't think QODBC verion 8 will work for us. Appreciate your comments and suggestions. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-11-20 07:54:00 |
You can aoverride your QODBC Optimizer configuration screen settings to suit what you are actually doing by using the following tags:
VERIFIED | VERIFY - Forces Full Resync with QuickBooks on the optimized table before Query starts CALLDIRECT | UNOPTIMIZED - Passthru query directly to QuickBooks - use no optimizations OPTIMIZE | OPTIMIZED | NOSYNC - Passthru query to optimized table directly for maximum speed
Examples:
select * from InvoiceLine UNOPTIMIZED select * from InvoiceLine NOSYNC select * from InvoiceLine VERIFIED
A select * from PurchaseOrder UNOPTIMIZED will not show deleted records. You should always be using the very latest version which is currently QODBC v8.
See: How can I get the latest version of QODBC? |
|
|
|
|