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
|
|
QBOE MS Access InvoiceLine Add Query made too many records. |
Author |
Message |
|
Posted : 2008-09-19 01:22:12 |
I am new to QODBC and am using QBOE.
I created a query in MS Access to create an invoice. She got away from me. It actually created thousands. How can I quickly and easily remove them? They all have the same invoice header info and exist in 2001--a year I never used. Any help is welcome.
Thanks in advance,
Steve |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-09-22 10:17:17 |
Just do:
DELETE FROM INVOICE where TxnDate = {d'YYYY-MM-DD'}
and change YYYY-MM-DD to the date of all those bad invoices! |
|
|
|
|
Posted : 2008-09-25 22:49:19 |
Tom, I have run the query a few times and it returns with no feedback or changes. Is it possible that QBOE is swatting me down since we are dealing with over a thousand records? Suggestions? Thanks again in advance, Steve |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-09-26 08:14:21 |
Correct, when over 1000 records could be returned by any given query to the QuickBooks Online Edition, the query get's terminated by QBOE at the Intuit end. |
|
|
|
|