|
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
|
|
| Does call Stored Proc optimized in new QODBC |
| Author |
Message |
|
|
| Posted : 2007-10-14 05:11:00 |
I am using SP like this
sp_report CustomerBalanceDetail show Date, RowData, Amount, AmountDifference, DueDate, OpenBalance, PaidStatus, TxnType, SalesRep parameter DateMacro = 'All' where PaidStatus = 'Unpaid'
It is working hours on QODBC 6.0 with QB 2005. 300Mb Database.
Will it work faster with new QODBC? Should I update QB as well?
Thanks |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-10-14 22:09:04 |
Yes QODBC v8 and QuickBooks 2008 is faster, but it's the report that's the real problem here. The report is taking all the transactions from year dot and then checking if they are unpaid, but in reality you only need to check the current period.
All the predefined DateMacro options available to you are:
|All|Today|ThisWeek|ThisWeekToDate|ThisMonth|ThisMonthToDate|ThisQuarter|ThisQuarterToDate
|ThisYear|ThisYearToDate|Yesterday|LastWeek|LastWeekToDate|LastMonth|LastMonthToDate|LastQuarter
|LastQuarterToDate|LastYear|LastYearToDate|NextWeek|NextFourWeeks|NextMonth|NextQuarter|NextYear|
Try:
sp_report CustomerBalanceDetail show Date, RowData, Amount, AmountDifference, DueDate, OpenBalance, PaidStatus, TxnType, SalesRep parameter DateMacro = 'ThisYear' where PaidStatus = 'Unpaid'
|
|
|
|
|