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
|
|
DISTINCT not working with v7 |
Author |
Message |
JimK |
|
Group | : Members |
Posts | : 34 |
Joined | : 2006-08-08 |
|
Profile |
|
Posted : 2006-11-29 11:14:02 |
Tom, the following statement does not seem to be working: SELECT DISTINCT CustomerRefFullName FROM Timetracking where billablestatus='Billable'. It is returning the customers with billable time but the results include duplicates (I get the EXACT same results if I take out the DISTINCT keyword). I'm using the VBDEMO program to test the statement. Obviously I'm using QBE v7 and QODBC v7.x.200.
For reference, the statement SELECT distinct customerreffullname from timetracking where isbillable=true and isbilled=false works on QBE v6 and QODBC v6 (no duplicates) with the same .QBW file (copies obviously).
Any ideas? Thanks! |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-11-29 12:23:13 |
Distinct is currently not passed through to the QODBC optimizer SQLite backend correctly in v7.00.00.199. You can workaround this by calling QuickBooks directly using the UNOPTIMIZED tag, which is a little slower, but it works:
SELECT DISTINCT CustomerRefFullName FROM Timetracking UNOPTIMIZED where billablestatus='Billable' |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-01-03 09:54:58 |
DISTINCT now functions correctly in QODBC v7.00.00.204 |
|
|
|
|