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
|
|
MS Access and UNOPTIMIZED tag |
Author |
Message |
|
Posted : 2007-05-24 03:02:39 |
This qb link can be very fustrating, especially when you toss in a little Microsoft Access and it's quirky behavior. I am generating a SQL query and prints out a report using the following sql statement.
SELECT TimeTracking.ClassRefFullName, TimeTracking.EntityRefFullName, TimeTracking.TxnDate AS StartDate, TimeTracking.TxnDate AS EndDate, (TimeTracking.DurationMinutes/60) AS DurationHours FROM TimeTracking AS UNOPTIMIZED WHERE (((TimeTracking.TxnDate)>=[@StartDate] And (TimeTracking.TxnDate)<=[@EndDate]));
The problem occurs when I run it from different workstations. I'd like to disable the optimizer when running this report so I've tried to add the UNOPTIMIZED tag after the FROM TimeTracking...well access keeps tossing in "AS" before it and the query stops functioning.
Any help would greatly be appreciated. Chris
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-05-24 13:24:20 |
AS UNOPTIMIZED will work fine if you run the query as a PASS-THROUGH query.
|
|
|
|
|