|
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
|
|
| Query not bringing in full table. |
| Author |
Message |
| Gary |
| |
| Group | : Members |
| Posts | : 3 |
| Joined | : 2006-06-01 |
|
| Profile |
|
| Posted : 2008-09-19 01:50:17 |
I'm running a query that has always worked with all of my customers but for one particular customer it does not find every record. It will bring in most of the records but not all. The query is:
Select Name, ListID, COGSAccountRefListID, IsActive FROM ItemInventory order by Name
I found that if I go into QuickBooks and change the record in any way and then save it, the above query will recognize the record.
The customer uses QB Enterprise 2008. |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-09-22 10:14:03 |
Try:
Select Name, ListID, COGSAccountRefListID, IsActive FROM ItemInventory UNOPTIMIZED order by Name
instead. |
|
|
|
|